Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 🙂
Solved! Go to Solution.
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'))
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'))
Thank you 🙂
User | Count |
---|---|
90 | |
85 | |
66 | |
62 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
82 | |
71 |