Power BI, a measure is not distributed over a certain code in a matrix visual

Hi all,

I need help & I think a planning engineer would easily understand the situation.

I've 4 tables, named TActDB, TCodes, TAPerc & TDate (which is recognized as date table).

1. TActDB linked to TCodes by one to one both direction relation via column named "Activity ID" (Unique).

2. TActDB linked to TAPerc by one to many relationship via same column "Activity ID" ( See Pic#1)Pic#1

    

3. in table TAPerc I've created a measure "**bleep** EMH" (i.e.: Cumulative Earned Manhour = ∑EMH) with the below DAX.

**bleep** EMH = IF(SUM(TAPerc[EMH])=0,BLANK(),CALCULATE(SUM(TAPerc[EMH]),FILTER(ALL(TAPerc),TAPerc[DDate]<=MAX(TDate[Date]))))

4. The 4th table "TDate" which I use to filter date thru a slicer. And the TAPerc have the progress under each date (weekly basis), and have been unpivot during the power query. This is why in the DAX above I used "All(Table)" to supersede any filtered dates and then want it to apply the calculations as long as the date is <= the max applied date in the slicer.

now the issue is when i used a matrix visual it couldn't distribute the **bleep** EMH over the building, noting that building is a column under the table TCodes (See Pic#2)

I tried having the one to many relationship to be both directions and single, but neither didn't work.

I don't know why it's unable to distribute the **bleep** EMH over the buildings and how to resolve the issue.