Forum Discussion

aleon's avatar
aleon
Frequent Visitor
8 years ago
Solved

Calculate total percent

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 th...
  • aleon's avatar
    aleon
    8 years ago

    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.

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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's avatar
aleon
Frequent Visitor
8 years ago

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.