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!