Solved: average total matrix

Syndicate_Admin · ‎09-30-2021

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

mattww · ‎09-30-2021

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:

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Matt

v-shex-msft · ‎10-04-2021

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:

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

mattww · ‎09-30-2021

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:

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Matt

average total matrix