Forum Discussion

mandyhpnguyen's avatar
mandyhpnguyen
Regular Visitor
3 years ago
Solved

Fix Matrix Total in Dax Measure Column with Condition and Variables in Power BI?

Hi everyone,    I have another Power BI Matrix Total issue as follows and hope you can help me with it.   I have a made-up dataset (end of this post) that is as close to my real project as possib...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi mandyhpnguyen ,

    This is because the context is difference, please try to create two new measure according to your original measure, try below dax formula:

    Adjust Headcount = SUMX(VALUES('Table'[Animal Type]),[HeadCount])
    Adjust Working Hour = SUMX(VALUES('Table'[Animal Type]),[Working Hour])

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi mandyhpnguyen ,

This is because the context is difference, please try to create two new measure according to your original measure, try below dax formula:

Adjust Headcount = SUMX(VALUES('Table'[Animal Type]),[HeadCount])
Adjust Working Hour = SUMX(VALUES('Table'[Animal Type]),[Working Hour])

Please refer the attached .pbix file.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • mandyhpnguyen's avatar
    mandyhpnguyen
    Regular Visitor
    3 years ago

    Thanks!

     

    This is the correct solution for my particular case!

    Best,

    Mandy