Forum Discussion

John_Peter's avatar
John_Peter
Regular Visitor
6 years ago
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...
Need Help
  • HotChilli's avatar
    HotChilli
    6 years ago

    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.

HotChilli's avatar
HotChilli
Community Champion
6 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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