which COUNT function to use?

Question

I am trying to create a measure for % On Time Delivery.

I have a column that lists the number of days a task takes. Our goal is under 90. I tried writing a measure that was:

% OTD = DIVIDE(COUNTAX('board-Query', 'board-Query'[Lot Disposition Duration] < 90), COUNTROWS('board-Query'))

But I keep getting 100% or over 100%...which is not true!!! :(

How do I count the number of rows who's values are 90 or less?

Thanks :)

cmcmahan · Accepted Answer

You're using 'board-Query'[Lot Disposition Duration] < 90 as the expression that you're counting.

Try this:

% OTD = DIVIDE(COUNTROWS(FILTER('board-Query', 'board-Query'[Lot Disposition Duration] < 90)), COUNTROWS('board-Query'))

Forum Discussion