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 Everyone,
Here in the above screenshot, I tried calculating the values as the ''Percent of grand total'' in Power BI. But it's calculating column-wise only. I tried other options as well like show value as ''Percent of column total'' and ''Percent of row total''.
I tried to populate the same thing in excel and I am able to do so. Please help me how to get the same excel result in Power BI. I am using table/matrix visuals in Power BI.
Thanks in advance!
Solved! Go to Solution.
@GarvitaSingh , for % of grand total, create a measure like
divide([measure], calculate([measure], allselected()) )
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s
Thank you very much @amitchandak for your help!
I am facing one more problem, values in the above snapshot are not coming in sequence. The Datatype of the above column is text. How can I get them in sequence?
@GarvitaSingh , for % of grand total, create a measure like
divide([measure], calculate([measure], allselected()) )
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s
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 |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |