Forum Discussion

BricioJ's avatar
BricioJ
Frequent Visitor
3 years ago

Percentage

I need to show the percentage above the total that represent the category (SMB, OTHERS) in the columns, basically I need what is in the chart but in the columns. i need to represent what is the percentage of each category (OTHERS, SMB) over the total 

 

Need Help

4 Replies

  • VilmarSch's avatar
    VilmarSch
    Post Partisan
    3 years ago

    Veja se ajuda

     

    Total = 
CALCULATE ( SUM ( Tabela[Horas ejecutadas] ), ALL ( Tabela[Proyecto] ) ) & " ("
    & FORMAT (
        DIVIDE (
            CALCULATE ( SUM ( Tabela[Horas ejecutadas] ), ALL ( Tabela[Proyecto] ) ),
            CALCULATE ( SUM ( Tabela[Horas ejecutadas] ), ALL () )
        ),
        "#0.00%"
    ) & ")"

    • BricioJ's avatar
      BricioJ
      Frequent Visitor
      3 years ago

      Thanks it works, but now, what if i want to filter by project or by owner, this is calculating over the total of hours but if i select the owner or a project it's showing the same value as the general.

      (For example applying this filter, the total of hours are 33 that represents the 100% but it shows that is 8,87% because is showing over the total)

       

       

      • VilmarSch's avatar
        VilmarSch
        Post Partisan
        3 years ago

        Tente este:

        Total = 
SUM ( Tabela[Horas gecutadas] ) & " ("
    & FORMAT (
        DIVIDE (
            SUM ( Tabela[Horas gecutadas] ),
            CALCULATE ( SUM ( Tabela[Horas gecutadas] ), ALLSELECTED ( Tabela ) )
        ),
        "#0.00%"
    ) & ")"
  • vanessafvg's avatar
    vanessafvg
    Community Champion
    3 years ago

    can you demonstrate what you are wanting as a solution, please provide an example, also if you have some sample data?