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.
I need help with calculating percentage of grand total instead of summarization.
Correct result would be ST/MT = 56,76 / 292,00 = 19,4% instead of 1617,6%.
Any ideas?
Using measure isntead of column fixed the issue.
Awesome.
if the solution helps and your issue is resolved. please mark the post as resolved to motivate us.
Regards,
Deevaker Goel
+91-9711975011
Hi,
Can you please confirm if the column in format section is doing sum. if yes you can use average
Also, The better option is to create a measure instead of column with below calculation
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 |
---|---|
97 | |
96 | |
82 | |
74 | |
66 |
User | Count |
---|---|
121 | |
105 | |
102 | |
82 | |
72 |