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
Icon for Community Champion rankCommunity 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])

 

 

  • John_Peter's avatar
    John_Peter
    Regular Visitor
    6 years ago

    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
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      John,

      Did you get a resolution so your total as a sum and not calculating correctly?