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 want to know the calculation behind the "Percent of Grand Total". How this calculates the percent?
And I want to know difference in calculation behind Clustered Column Chart(Percent of Grand Total) and 100% Stacked Bar Chart because I'm getting different results in both. 100% Stack Bar Chart is showing the right results which I want but I want the same figures in Clusteres Column Chart.
Looking forward to the brief explaination.
Solved! Go to Solution.
HI @Anonymous ,
In fact, it is a simple percent calculate. (current legend amount divide with total amount and grouped by current data category)
Measure = DIVIDE ( CALCULATE ( SUM ( Table[sales] ), VALUES ( Table[Category] ), VALUES ( Table[Legend] ) ), CALCULATE ( SUM ( Table[sales] ), VALUES ( Table[Category] ) ) )
If above not help, please share some sample data with table data structure for test.
Regards,
Xiaoxain Sheng
HI @Anonymous ,
In fact, it is a simple percent calculate. (current legend amount divide with total amount and grouped by current data category)
Measure = DIVIDE ( CALCULATE ( SUM ( Table[sales] ), VALUES ( Table[Category] ), VALUES ( Table[Legend] ) ), CALCULATE ( SUM ( Table[sales] ), VALUES ( Table[Category] ) ) )
If above not help, please share some sample data with table data structure for test.
Regards,
Xiaoxain Sheng
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 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |