I have a Deliver Rate measure that calculates based on the running number count of deliveries completed divided by running average of items sold. This measure works greatly when choosing locations and time period. However, I noticed that when choosing delivery type, the measure fails.
But I want to check the delivery rate for deliveries made overseas, it would affect the running average part and throwing the whole measure off. Is it possible to having the running average part of the measure filter only by location and time but not be affected by other categories such as type and reason?
For example, delivery rate = running number count of 8 deliveries / running average of 10 items sold at a particular time = 80%. I then select delivery type “overseas”, and I get 6 deliveries / running average of 2 items sold when it should still stay as 10 items sold (6 / 10 = 60%). So it appears the “deliver type” is affecting the whole measure when I just want it affect the running number count and leave the running average as-is.
The Dax Measure for the Running Average of Items Sold:
2022 Curr Running Avg Items Sold =
ROUNDDOWN(
CALCULATE(AVERAGEX(VALUES('Date'[Year-Month]), [Items Sold])
,FILTER(ALL('Date'[Date]), 'Date'[Date] <= MAX('Date'[Date]) && YEAR([Date]) = 2022) )
, 0 )
So is possible to modify to only change when location and time periods (year, month, etc) are selected, but categories such as delivery type and reason it does not change?
