cancel
Showing results for
Did you mean:
Resolver I

How to calculate percentage of item by category

Hi,

I am trying to get percentage of a single item by category. The simplest way would be to calculate a measure for that specific item and overwrite the filter using ALL function. However, this doesnt work strangely. below is the screenshot of what i tried.

Measure :

Hrs = SUM('Table 1'[Hrs])

SAH = CALCULATE(SUM('Table 1'[Hrs]), ('Table 1'[Category] = "SAH", All('Table 1'[Category])

% from SAH = Divide(Total,SAH)

Below is the screenshot of the result:

Any suggestions would be helpful. Thanks!

1 ACCEPTED SOLUTION
Super User

@sujitjena try this

``SAH = CALCULATE(SUM('Table 1'[Hrs]), ('Table 1'[Category] = "SAH", All('Table 1')``

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

2 REPLIES 2
Super User

@sujitjena try this

``SAH = CALCULATE(SUM('Table 1'[Hrs]), ('Table 1'[Category] = "SAH", All('Table 1')``

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Resolver I

@parry2k : Thanks a lot, really a silly mistake 😊

Announcements

Launching new user group features

Learn how to create your own user groups today!