Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

matrix total is not correct

hello my spends total measure is made up of multiple different measure ,but if I try to get it on matrix it is not givint me correct total ...please help

 

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    Due to I don't know your data model, I will create a sample to show you how to achieve your goal.

    Sample:

    Measure:

    Average = AVERAGE('Table'[Sales])
    Average with correct Total = 
SUMX(VALUES('Table'[Category]),[Average])

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    Due to I don't know your data model, I will create a sample to show you how to achieve your goal.

    Sample:

    Measure:

    Average = AVERAGE('Table'[Sales])
    Average with correct Total = 
SUMX(VALUES('Table'[Category]),[Average])

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

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