Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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))
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.