Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
112 | |
100 | |
98 | |
72 | |
66 |