Forum Discussion

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
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.
Fix Matrix Total.pbix28 KB

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.

Fix Matrix Total.pbix28 KB