Forum Discussion
Quick Calc % Row Totals not working
How does the % Row Totals Quick Calc work? Column % totals, but my % row totals all say 100%.
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 :smileyhappy:
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...
11 Replies
Give this a try...
% of Parent Row Total Measure = IF ( ISFILTERED ( Table[Primary_Payor_Level_6] ), DIVIDE ( SUM ( Table[Value] ), CALCULATE ( SUM ( Table[Value] ), ALL ( Table[Primary_Payor_Level_6] ) ), 0 ), DIVIDE ( CALCULATE ( SUM ( Table[Value] ), ALL ( Table1[Primary_Payor_Level_6] ) ), CALCULATE ( SUM ( Table[Value] ), ALLSELECTED ( Table ) ), 0 ) )If you already have a Measure for the underlined part you can substitute it.
But that basically is what you have in the Values area of the Matrix! :smileyhappy:
Thank you, Sean. Yes, that works but I was hoping to use the new Quick Calc % Row Total, which should be automatic.
Yes we actually just got the 2nd and 3rd option in the February 2017 Update
Long way to go to match Excel... Until then we'll need to write the Measures :smileyhappy:
