Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Table Formula - Percentage

Hi all!

 

I would like to seek assistance from the experienced users in this forum.

 

Say that I have a table like this:

 

How can I make it in the PowerBI so I can make calculation with the values in 'Total Amount' column? I want to generate a Table/Matrix visual that looked like this:

 

Appreciate any inputs for this matter.

 

Thank you in advance.

 

Best regards,

Bona

Need Help
Tips and Tricks
Tutorial Requests
  • ERD's avatar
    ERD
    3 years ago

    Anonymous ,

    You can create measures like this:

    Group | (25%) = SELECTEDVALUE(Table__[Amount]) * 0.25

    or calculated column like this

    Group | (25%) = Table__[Amount] * 0.25

     

3 Replies

  • ERD's avatar
    ERD
    Community Champion
    3 years ago

    Anonymous ,

    You can create measures like this:

    Group | (25%) = SELECTEDVALUE(Table__[Amount]) * 0.25

    or calculated column like this

    Group | (25%) = Table__[Amount] * 0.25

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hello,

       

      Thank you for your response!

       

      I noticed that the formula seems to cover the 25% column. How to extend this formula for the other percentages/columns as well? Do I need to just make new measures to cover the other percentages?

      • ERD's avatar
        ERD
        Community Champion
        3 years ago

        Anonymous , taking account what you've shown you have, yes. Just create more measures/columns in the same way.