cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Penhoat Frequent Visitor
Frequent Visitor

Calculate Passrate (CountIf)

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:

  • TableName: evaluations
  • Column: q_percent

 

Thank you in advance

 

2 REPLIES 2
bwsutton1990 Regular Visitor
Regular Visitor

Re: Calculate Passrate (CountIf)

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

Penhoat Frequent Visitor
Frequent Visitor

Re: Calculate Passrate (CountIf)

Thanks! The data is slightly different than before, so let me double check before I mark it as a solution haha.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,360)