average total matrix

[Syndicate_Admin]

how do I make the average come out in the totals and not the sum?

[v-shex-msft]

Hi @lesterfernando,

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

[mattww · Accepted solution]

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