Forum Discussion
Help with SUMX DAX
I've been working on a Finance PVM (Price Volume Mix) Analysis in PowerBI and have been stuck with a SUMX DAX measure that doesn't return the intended value. I have tried multiple way-outs and even ...
kunwar2 , Not very clear. But make sure you measure is like
Sumx(Summarize(Fact, Dim[Col], Dim2[Col]), [Measure1]*[Measure2])
In it from two fact and across different dimesions
Sumx(Values(Dim[Col]), calculate(Sumx(Values(Dim2[Col]), [Measure1]*[Measure2]) ) )
You can use isinscope to change calculation for different level
example
How to Switch Subtotal and Grand Total in Power BI | Power BI Tutorials| isinscope: https://youtu.be/smhIPw3OkKA