Quick Calc % Row Totals not working

[ironryan77]

How does the % Row Totals Quick Calc work?  Column % totals, but my % row totals all say 100%. 

[Sean · Accepted 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))

[Sean]

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!

[ironryan77]

Thank you, Sean.  Yes, that works but I was hoping to use the new Quick Calc % Row Total, which should be automatic. 

[Sean]

@ironryan77

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

[ironryan77]

According to this site, % of Row Total should be working now also.

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-feature-summary/

[Vvelarde]

@ironryan77

the row total is working..because the row in quick calc is only 2015...so for all is 100% except when is blank

[ironryan77]

If I understand the purpose of Quick Calc % Total Row, then it should sum both 2015 and 2016 charges.  Otherwise, how would % Total Row be any improvement on No Calculation?  Also, this is how % Total Columns works except on Rows instead.

[Sean · Accepted 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))

[ironryan77]

I still don't understand how % of Row Total helps, but thank you for explaining all of the options.  I probably won't be using % of Row Total since I don't understand what it does.

[Sean · Accepted solution]

@ironryan77 

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...

[ironryan77]

Awesome!  This was exactly what I needed!

[Vvelarde]

@ironryan77

in your case 2015 charges and 2016 charges are different columns or measures. In the case of the % Column is the same column.

The improvement is when you have a Column to make the Calcs (In your case if you have Charge Year (2015,2016..)