Forum Discussion
Solved
Percentage Total calculation
Hi Power BI, I have a matrix with a column of%, it seems that the grand total of this column is the sum of the column, how can I do to make the% only at the level of the Grand Total? For examp...
It looks like these are calculated columns rather than measures. If so, this is the opposite of what 99% of people complain about powerbi totals (The values are being added up).
If Gross% is written as a measure, I think you'll get what you want. Obviously I can't see your source data so that's a semi-educated guess.
I am having the same issue. However, I am using a measure. Do i have to make it a calculated column? Below is my Measure.
Utilization = (sum(DirectLabor[ActualHours])+(CALCULATE(InDirect[Set Up]/3)))/CALCULATE([Avail])
Hi Anonymous
My Percentage is a Measure
Gross% = DIVIDE(SUM(Ventes[Gross$]),SUM(Ventes[Sales]),0)
Gross$ is a calculated Columns and Ventes[Sales] is a Column
John,
Did you get a resolution so your total as a sum and not calculating correctly?