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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Vidyashree
Frequent Visitor

Percentage summing up at higher hierarchy level

Hi,

 

I am facing issue with Percentage.  % is showing up correctly at leaf level as in image. But when I drill up it is summing up. 

 

Please help

 

Thanks in advance!!

%  at leaf level% at leaf level% summing up at higher level% summing up at higher level

3 REPLIES 3
Stachu
Community Champion
Community Champion

how is the percentage defined? is it a measure or a calculated column?
column would explain the summing up



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Its a calculated column. I cannot define the data type as "Percentage" because I have unpivoted this with some other columns which are whole numbers. Is there a way to define "IFR%" column alone as Percentage data type?

you should define it as a measure rather than column, then the aggregation will be fine
as long as the calculation doesn't happen on the fly for a given level (only possible with measure) it will always just sum the values from the column



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!