Percentage summing up at higher hierarchy level

[Vidyashree]

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

[Stachu]

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

[Vidyashree]

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?

[Stachu]

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