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.

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
Icon for Community Support rankCommunity 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!