Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
% summing up at higher level
how is the percentage defined? is it a measure or a calculated column?
column would explain the summing up
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