How to have measure differentiate calculations based off chart row?

[Anonymous]

I have a measure that is supposed to calculate the mean time between row events between each row.  I would like it done so that when drilling down a table/chart the "mean time between row events" is calculated based off the filtered subarray of that "more specific" row.

Currently it's correctly calculating this measure correctly for the main system, but incorrectly calculating the measure for the drilled down system (location in this example).

In this instance Pump A has 2 datapoints but it's only taking the time between every row in that system.

Time Between WO = 

VAR rowdate = CALCULATE(MAX([Date Reported]), FILTER(ALL(Sheet), Sheet[Date Reported] < MAX([Date Reported]) && Sheet[System] = MAX([System])))
VAR rowdatesystem = CALCULATE(MAX([Date Reported]), FILTER(ALLEXCEPT(Sheet,Sheet[Location]), Sheet[Date Reported] < MAX([Date Reported]) && Sheet[System] = MAX([System])))
return 
    DATEDIFF ( rowdate, MAX ( [Date Reported] ), DAY )

MTBF = 
AVERAGEX (Sheet, [Time Between WO])

This is my code.

[v-cazheng-msft]

Hi @Anonymous ,

Could you please provide some data from your tables that used in your formula and let me know how your build relationships for them? Thanks in advance!

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun