cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ejhornyak
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
parry2k
Super User III
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.






Did I answer your question? Mark my post as a solution.

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





View solution in original post

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

 

View solution in original post

2 REPLIES 2
parry2k
Super User III
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.






Did I answer your question? Mark my post as a solution.

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





View solution in original post

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

 

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.