Forum Discussion

rogeriosouzax's avatar
rogeriosouzax
Regular Visitor
7 years ago
Solved

Problem calculating percentage total - bar chart

Hello guys!   I'm new in Power BI :) I'm trying to create a bar chart to display my data but it's working partially.   I create a new measure to calculate the percentage of total. Follow my formu...
Need Help
Show and Tell
  • Vvelarde's avatar
    Vvelarde
    7 years ago

    rogeriosouzax

     

    Hi, try with this:

     

    Medida = DIVIDE(SUM(Table1[Valor]),CALCULATE(SUM(Table1[Valor]),ALLSELECTED(Table1[Faixa])))

    Regards

     

    Victor

     

Vvelarde's avatar
Vvelarde
Community Champion
7 years ago

rogeriosouzax

 

Hi, try with this:

 

Medida = DIVIDE(SUM(Table1[Valor]),CALCULATE(SUM(Table1[Valor]),ALLSELECTED(Table1[Faixa])))

Regards

 

Victor

 

rogeriosouzax's avatar
rogeriosouzax
Regular Visitor
7 years ago

Hi Vvelarde,

 

It works!!! Thank you!

Just a point that I want to share. When I try to "Sort by column" using a different column  I have the following behavior.

Using a different field to Sort By Column

All columns displays 100%, it's crazy, isn't it? kkk

Well, it's working as I need now (I will use the default "sort").

 

Thank you v-yuta-msft and Vvelarde for help!

 

Best regards,

 

Roger