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.
How does the % Row Totals Quick Calc work? Column % totals, but my % row totals all say 100%.
Solved! Go to Solution.
@ironryan77 and @Vvelarde
People take these things to mean the same but they are different % of Row Total and % of Parent Row Total
See Below
No Calculation | Displays the value that is entered in the field. |
% of Grand Total | Displays values as a percentage of the grand total of all the values or data points in the report. |
% of Column Total | Displays all the values in each column or series as a percentage of the total for the column or series. |
% of Row Total | Displays the value in each row or category as a percentage of the total for the row or category. |
% Of | Displays values as a percentage of the value of the Base item in the Base field. |
% of Parent Row Total | Calculates values as follows: (value for the item) / (value for the parent item on rows) |
% of Parent Column Total | Calculates values as follows: (value for the item) / (value for the parent item on columns) |
% of Parent Total | Calculates values as follows: (value for the item) / (value for the parent item of the selected Base field) |
Difference From | Displays values as the difference from the value of the Base item in the Base field. |
% Difference From | Displays values as the percentage difference from the value of the Base item in the Base field. |
Running Total in | Displays the value for successive items in the Base field as a running total. |
% Running Total in | Calculates the value as a percentage for successive items in the Base field that are displayed as a running total. |
Rank Smallest to Largest | Displays the rank of selected values in a specific field, listing the smallest item in the field as 1, and each larger value with a higher rank value. |
Rank Largest to Smallest | Displays the rank of selected values in a specific field, listing the largest item in the field as 1, and each smaller value with a higher rank value. |
Index | Calculates values as follows: ((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total)) |
This kind of oversimplifies it (especially the bottom example) because I had to apply slicers so you don't exactly see the benefit of the % of Parent Row Total (and in this case it looks like % of Column Total even though its not) but just to give you an idea...
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 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |