Reply
Member
Posts: 140
Registered: ‎01-03-2017

Re: Average by group and not by number of items.

Hello @v-jiascu-msft

 

Here it goes

Group by average

 

In this case I have 7,5 as average on each group on in fact I was looking for 45 divide by 2 ElementsID (1 and 2). 
Sum of all timeInstatus in Group1 divided by the number of elements in my case 2.

 

Thanks

 

Highlighted
Community Support Team
Posts: 7,693
Registered: ‎05-02-2017

Re: Average by group and not by number of items.

Hi @rmachado,

 

Please try this one which is similar to the last one.

Measure = 
DIVIDE ( SUM ( Elements[TimeInStatus] ), distinctCOUNT ( 'Elements'[ElementID] ), 99999 )

Average-by-group-and-not-by-number-of-items2

 

Best Regards,
Dale

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