Forum Discussion

Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
4 years ago
Solved

Incorrect measure total in Matrix

Hi Experts, Greg_Deckler  I have tried using summarize, sumx and hasonevalue function still giving incorrect result in total. I have used 3 different measure which I have written below Measure 1 ...
Need Help
  • Tahreem24's avatar
    Tahreem24
    4 years ago

    Uzi2019 , Try to use something like below:

    IF(HASONEFILTER('Table'[Month]),C*(%Sum),SUMX(VALUES('Table'[Month]),C*(%Sum)))
     
    Hopefully it may help you out.
     
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
4 years ago

Uzi2019 , Try to use something like below:

IF(HASONEFILTER('Table'[Month]),C*(%Sum),SUMX(VALUES('Table'[Month]),C*(%Sum)))
 
Hopefully it may help you out.
 
Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
4 years ago

Tahreem24 

I got my total corretly. thank you so much.