Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
ironryan77
Advocate II
Advocate II

Quick Calc % Row Totals not working

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

quick calc row totals.jpg

2 ACCEPTED SOLUTIONS
Sean
Community Champion
Community Champion

@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 Smiley Happy

 

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

View solution in original post

Sean
Community Champion
Community Champion

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

 

% of Row and % of Parent Row.png

View solution in original post

11 REPLIES 11

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.