Forum Discussion
average total matrix
how do I make the average come out in the totals and not the sum?
What is the measure being used in that visual?
The reason that's happening is to do with the DAX and how it's evaluated in the total cells, not a setting on the visual
Check out this blog to start with, it might give you an idea of what's going wrong in your DAX:
Obtaining accurate totals in DAX - SQLBI
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Matt
2 Replies
What is the measure being used in that visual?
The reason that's happening is to do with the DAX and how it's evaluated in the total cells, not a setting on the visual
Check out this blog to start with, it might give you an idea of what's going wrong in your DAX:
Obtaining accurate totals in DAX - SQLBI
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Matt
Hi Anonymous,
You can take a look at Greg's blog to know more about how to handle the total level calculations of measure expressions:
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
