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 ...
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

     

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.