Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hi, guys, Im having a hard time here, trying to get a with the proper DAX formula, I have a measure = (a/b)
But for the total I want the sum of the values for that column, instead the total A / Total B.
Im going to attach an image of an example model to better explain my problem.
I tried to use a combination of sumx with values (country for example), but it works only for that attribute, If I remove for example country, and add brand to the pivot the measure shows the wrong total.
Thanks a lot for your help
Solved! Go to Solution.
@ctrip77 Please use following measure to get the correct totals.
Measure = SUMX('Table',DIVIDE('Table'[Cost],'Table'[area Ft2],0))
@ctrip77 Please use following measure to get the correct totals.
Measure = SUMX('Table',DIVIDE('Table'[Cost],'Table'[area Ft2],0))