cancel
Showing results for
Did you mean:
Frequent Visitor

Count number of times a measure equals a value

I have a measure that calculates a % at a location level. I am having a hard time writting a measure to count the number of times that measure equals 100%.  The goal is to count the number of locations that got a 100% in a region and get a % of locations in that region that attained that score.

Not sure if it is possible to count the number of times a measure equals a specific value.

2 ACCEPTED SOLUTIONS
Super User III

@ejhornyak add another measure to count

``````Count of 100% =
SUMX ( VALUES ( Table[Location] ), IF ( [% Measure] = 1, 1, 0 )``````

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

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.

Frequent Visitor

Thank you for the quick response.  That seems to have done the trick!

2 REPLIES 2
Super User III

@ejhornyak add another measure to count

``````Count of 100% =
SUMX ( VALUES ( Table[Location] ), IF ( [% Measure] = 1, 1, 0 )``````

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

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.

Frequent Visitor

Thank you for the quick response.  That seems to have done the trick!

Announcements