Forum Discussion
Measure Help!
Hi Anonymous
Sure, please try this measure
Measure 1 = var _ZeroQty = COUNTROWS(CALCULATETABLE(VALUES('Table'[sales_order_number]),'Table'[OTIF]=0)) var _total = DISTINCTCOUNT('Table'[sales_order_number]) return IF(ISINSCOPE('Table'[sales_order_number]),IF(_ZeroQty=0,1,0),1-DIVIDE(_ZeroQty,_total))Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi Anonymous - Modified to remove the filters in above measure can you try this?
OTIF Without Dupes V4 =
VAR OrdersTable =
SUMMARIZE(
'OTIF Showcase Sales order rollup',
'OTIF Showcase Sales order rollup'[Location ID_Desc],
'OTIF Showcase Sales order rollup'[sales_order_number],
"OnTime", MAX('OTIF Showcase Sales order rollup'[On time])
)
VAR TotalOrders =
CALCULATE(
COUNTROWS(OrdersTable),
REMOVEFILTERS('OTIF Showcase Sales order rollup'[sales_order_number])
)
VAR OnTimeOrders =
CALCULATE(
COUNTROWS(
FILTER(OrdersTable, [OnTime] = 1)
),
REMOVEFILTERS('OTIF Showcase Sales order rollup'[sales_order_number])
)
RETURN
DIVIDE(OnTimeOrders, TotalOrders, 0)
I hope it works,
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
k
rajendraongole1 , any advice on getting the above requirement added in the measure?
Hi Anonymous
Please check if this can meet your requirement. You can download the pbix to see details.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!j