Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I looked around at what's already asked, but it doesn't really work for me.
=COUNTIF([column1],">84.99")/COUNTIF([column1],"*")
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
Hi
You should use a combination of CALCULATE, COUNT & FILTER, as below:
CALCULATE( COUNTROWS(evaluations), FILTER(evaluations, [column1] > 84.99) ) / COUNTROWS(evaluations)
Hope that helps
Thanks! The data is slightly different than before, so let me double check before I mark it as a solution haha.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |