Calculate total percent

[aleon]

Hello, I have a Table on Power BI with a column of %, and on the total column in stead of calculate the total %, power bi puts the sum of the percentages:

How can I tell Power BI to calculate the total % in stead of sum all the %?

[v-huizhn-msft]

Hi @aleon,

The column of % is geted from a measure or a column direct from your resource table? Or there is any calculation for the % column? Could you please share your sample table or .pbix file for troubleshooting?

Best Regards,
Angelia

[aleon · Accepted solution]

Hello Angelia,

Finally I found how to solve it. In stead of create a new column for the percentage, I used a measure and it calculates the total percentage correctly.

Thanks for your help!!

Best regards.