Average of datediff measure

[PrieleBI]

Hello,

How to calculate average of dateiff measure? (see the picture below)

In this case measure calculates time between firs IN and last OUT (373,5) and it is wrong -  I need the average of it

(51+71+45+56+51)/ 5 = 54,8

1 row = 1 route ID

[Anonymous]

Thank you Greg_Deckler 

Hi, @PrieleBI 

What you are showing is usually when you use some complex calculations in your measure, which causes the Total row to be displayed incorrectly. This is normal behavior. The external filter-row label is lost in the Total row. We need to manually fix this error and specify the calculation logic corresponding to the Total row.

The isinscope function is mainly used here:

Measure = 
IF(ISINSCOPE('Table'[IN]),[TIME S],AVERAGEX(VALUES('Table'[IN]),[TIME S]))

When we change the time range, the Total row will be calculated according to the calculation logic we specified and the correct result will be obtained.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@PrieleBI This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.