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.

  • John_Peter's avatar
    John_Peter
    Regular Visitor
    6 years ago

    Thanks,

     

    Then i will change the column to a Calculated columns ğŸ˜€

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      6 years ago

      Hi John_Peter ,

       

      Is your issue solved?Can you make it as answered to close it?

       

       

      Best Regards,
      Kelly
      Did I answer your question? Mark my post as a solution!
  • 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?