topic Count a single percentage value in a column in DAX Commands and Tips

Count a single percentage value in a column

Anonymous — Fri, 22 Sep 2023 01:13:25 GMT

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 — Fri, 22 Sep 2023 07:53:45 GMT

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