Matrix Total Count Repeat Each Line

[UncleLewis]

Hi all,

I am trying to get Lifetime count of repairs and retun the same count on every line reagrdless of other context in Matrix/Table
In the screen shot, I'm getting "1" on each line. I'm trying to return the total count of repairs for the SN on each line so each line should show "5"

Here's my current Measure: (I've tried many versions, but nothing is quite right)

SN Repair Count =

CALCULATE(

[Total Repair Count],

FILTER(SN,SN[SN]=SELECTEDVALUE(SN[SN]))

)

Thanks,
-w

[UncleLewis]

Thanks Ashish,

That works as long as I only have SN and WO in the Matrix.
As soon as I add a new field to the Matrix, the Value goes back to displaying 1 on the Row Value.
Is there a way to use ALLEXCEPT or other function to handle all cases whether I have 1-2 items on Rows or 30?

Thanks,
-w

[UncleLewis · Accepted solution]

I ended up using Aggregated Table to solve this problem.
Now every row in the Table/Matrix shows the total count of repairs based on the S/N and regardless of Filter Context.

Aggregated Tables may not solve all Power BI reporting needs - but definitely solved this one.

Thanks,
-w

[Ashish_Mathur]

Hi,

Does this measure work?

SN Repair Count = CALCULATE([Total Repair Count],ALL(SN[WO]))

[UncleLewis]

Thanks Ashish,

Sorry, that does not work
I tried changing to ALL(SN[SN]) since WO does not exist in table SN
I uploaded the pbix here

Thanks,
-w

[Ashish_Mathur]

Hi,

This measure works

SN Repair Count_2 = if(isblank([Total Repair Count]),blank(),CALCULATE([Total Repair Count],ALL(Data[WO])))

Hope this helps.