Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
When I create a measure that calculates a division ("/") between two different numbers and I place it on a Table, I get the average of each result in the Grand Total row.
If I use the +,- or * signs Power Bi will calculate a sum in the total instead.
Can I get this with a divison as well?
My dax is:
My new measure = SUM('CUBE'[column A])/[Measure 1])
FYI: Measure1 is only a "distinct count"
Example of what Power Bi does:
Cities | My Measure |
Paris | 22.36 |
Milan | 5.33 |
London | 11.8 |
Grand total | 13.16333 |
What I want:
Cities | My Measure |
Paris | 22.36 |
Milan | 5.33 |
London | 11.8 |
Grand total | 39.49 |
Solved! Go to Solution.
Hi @Anonymous
You may try below measure:
Measure = IF ( HASONEVALUE ( 'CUBE'[Cities] ), [My new measure], SUMX ( VALUES ( 'CUBE'[Cities] ), [My new measure] ) )
Regards,
Cherie
Hi @Anonymous
You may try below measure:
Measure = IF ( HASONEVALUE ( 'CUBE'[Cities] ), [My new measure], SUMX ( VALUES ( 'CUBE'[Cities] ), [My new measure] ) )
Regards,
Cherie
Thanks a bunch this has done the trick!
😄
Hi @Anonymous
Kindly mark my answer as a solution if you feel that makes sense.
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
87 | |
61 |