DAX: Count based on Multiple criteria

[LABrowne]

Hi there,

Currently working on a formula where I need to count the number of orders based on following criteria: (1) the order saturation is over 100% and (2) the order is between it's delivery date (seperate column) and expiry date (again another seperate column). So far I have the following formula meeting criteria (1) but need to include (2) into the formula, please see below:

Active Order Count (Order Saturation > 100%) = COUNTX(VALUES(Order[OrderNumber]),IF([OrderSat] > 1,1))

Any help amending the formula to add an additional criteria to also only count orders between their delivery and expiry date would e much appreciated!

Kind regards,

Luke

[Walter_W2022]

Hi @LABrowne please try below, you can tweak it to fit your needs

Active Order Count (Order Saturation > 100%) = COUNTX(VALUES(Order[OrderNumber]),IF([OrderSat] > 1 && DATEDIFF ( [delivery date], [expiry date], DAY )>=0,1))

[LABrowne]

Hi Walter,

Thanks for your assistance but it is only letting me select measures where as delivery date and expiry date are not measures, I'm not sure why?

Thanks,

Luke