I have a table of Orders with a Related Date Table and Reasons Table which is a table that has reasons for Failure.
I have a Base Failure Measure -
Orders Failed = CALCULATE([Orders Dispatched], FILTER(Orders, Orders[Reason] <> “”))
An Orders Dispatched measure that gives me the number of all Orders that are Dispatched in the Current Context.
Orders Dispatched = DISTINCTCOUNT(Orders[Order Reference])
I then try to Calculate the Failure % against the dispatched with the following Failure % = DIVIDE([Orders Failed], [All Orders Dispatched], 0) which is fine until I put the Reason Type on the Pivot where I then get 100%.
Am I correct in thinking that I would need an All Reasons Orders Dispatched to keep any Date Context but ignore the Reasons.
Such as - All Orders Dispatched = CALCULATE([Orders Dispatched], ALL(Orders[Reason]))
Hopefully this will make sense.
Any help gratefully received.