Average Dax

Hello cristianml 

I think this post already exists. We tried already to help, but where not able.

A measure in a pivot table will be filtered on row level (in your row "Irland" and "Senior management"). But if we are coming to a grand-total it's simple no filter applied. This means you are not getting the average of the averages calculated in the upper row levels, but the overall average of your data, witch its all different.

In this scenario you can use 2 different measures on row level and grandtotal. To do the average of all averages you may only be able to in a static way using SUMMARIZE and ADDCOLUMNS. But maybe somebody else is able to help

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy