Forum Discussion
Measure for group average
I have a measure for calculationg average of number of days since last input. I want to have another measure showing group average after filtering specific project to compare project with the gr...
Hi Anonymous ,
Try this:
average = AVERAGE ( 'Table'[Days average] )
divisional average = AVERAGEX ( 'Table', CALCULATE ( AVERAGE ( 'Table'[Days average] ), ALLEXCEPT ( 'Table', 'Table'[Group] ) ) )
Best Regards
IceyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I created this sample of data :
| Product | Group | Days average |
| a | abc | 50 |
| b | abc | 60 |
| c | abc | 80 |
| d | abc | 100 |
| e | abc | 500 |
| f | abc | 100 |
| h | abc | 50 |
| i | abc | 60 |
| j | def | 70 |
| k | def | 100 |
| l | def | 100 |
| m | def | 120 |
| n | def | 140 |
| o | def | 150 |
| p | def | 160 |
I want to have a measure showing average for product(s) and another one showing average for division. (i will have 2 cards next to each other for comparison)
e.g. when i select project a it gives me : average 50, divisional average 125
Anonymous you can achieve this by following measures
Average by group = CALCULATE(AVERAGE('Table 2'[Days average]),ALL('Table 2'[Product]))
Average by Product = CALCULATE(AVERAGE('Table 2'[Days average]),ALL('Table 2'[Group]))