Divide using DistinctCount NOT at Row Level

[patri0t82]

Hello,

I have a simple enough DAX measure:

1YR Trailing MTBF =

DIVIDE('MTBF - Combined'[Asset Count] ,

(CALCULATE( SUM('MTBF - Combined'[Failure]), DATESMTD(DATEADD(CalendarTable[Calendar],0 , MONTH )))

)

) * 12 + 0

The portion I'm having a problem with is blue. At each row level in the visualization, 'MTBF - Combined'[Asset Count] is only representing the total for the month. I need my formula to use the total for the entire table. IE 2,392 instead of only 22 (for the one month).

I tried using DISTINCTCOUNT, but it's the same result. Is there a simple way to capture the total number of assets in my measure?

[patri0t82 · Accepted solution]

I was able to resolve the issue using the ALL function inside CALCULATE:

1YR Trailing MTBF =

DIVIDE(CALCULATE(DISTINCTCOUNT('MTBF - Combined'[Equipment ID]),ALL('MTBF - Combined')),

(CALCULATE( SUM('MTBF - Combined'[Failure]), DATESMTD(DATEADD(CalendarTable[Calendar],0 , MONTH )))

)

) * 12 + 0