Solved: Count a single percentage value in a column

Anonymous · ‎09-21-2023

This seems like it should be easy but I'm stumped. All I want to do is count the number of times the Completion rate column has the 0.0% value in it.

JoeBarry · ‎09-22-2023

Hi @Anonymous

You will need to crate a measure

Measure = CALCULATE(COUNT(Table[Completion rate], KEEPFILTERS([Completion rate] = 0)

Thanks

Joe

If this post helps, then please Accept it as the solution

JoeBarry · ‎09-22-2023

Hi @Anonymous

You will need to crate a measure

Measure = CALCULATE(COUNT(Table[Completion rate], KEEPFILTERS([Completion rate] = 0)

Thanks

Joe

If this post helps, then please Accept it as the solution

Count a single percentage value in a column