Hello everyone,I looked around at what's already asked, but it doesn't really work for me.
The above is my Excel formula, and what I'm trying to do is calculate the passrate. Every score goes up to 100, and I'm trying to calculate the percentage of scores that have passed the above criteria.
In Powerbi I have:
Thank you in advance
You should use a combination of CALCULATE, COUNT & FILTER, as below:
FILTER(evaluations, [column1] > 84.99)
Hope that helps
Thanks! The data is slightly different than before, so let me double check before I mark it as a solution haha.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!