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.

Thennarasu_R's avatar
Thennarasu_R
Icon for Responsive Resident rankResponsive Resident
3 years ago

Hi mandyhpnguyen 

Could you use this Measure.

Some times in Matrix Visual Calculate the total wrongly so that case We Can require this error 
First thing will Create a one measure
then,
Aply old measure into New measure.If we can apply in variables It won't work thats why This mandatory.


1  Actual Sales=Calculate(SUM(Sales))
2  Total Output  = Calculate(SUMX( VALUES (Accuracy[Product Name]), calculate (SUMX( VALUES (Accuracy[Product Name]), [ Actual Sales] )))
)


Thanks ,
Thennarasu
  • mandyhpnguyen's avatar
    mandyhpnguyen
    Regular Visitor
    3 years ago

    Thanks,

     

    I got the exact solution in the comment below but you helped to explain the case!

     

    I really appreciate it!

     

    Best,

    Mandy