Forum Discussion

sy898661's avatar
sy898661
Helper V
7 years ago
Solved

which COUNT function to use?

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(CO...
Need Help
  • Cmcmahan's avatar
    Cmcmahan
    7 years ago

    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'))

     

Cmcmahan's avatar
Cmcmahan
Resident Rockstar
7 years ago

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'))

 

  • sy898661's avatar
    sy898661
    Helper V
    7 years ago

    Thank you :)