Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

average total matrix

how do I make the average come out in the totals and not the sum?
  • mattww's avatar
    4 years ago

    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