topic Re: DAX: Count based on Multiple criteria in DAX Commands and Tips

DAX: Count based on Multiple criteria

LABrowne — Fri, 27 Oct 2023 09:39:51 GMT

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

Re: DAX: Count based on Multiple criteria

Walter_W2022 — Fri, 27 Oct 2023 10:07:46 GMT

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))

Re: DAX: Count based on Multiple criteria

LABrowne — Wed, 01 Nov 2023 13:32:18 GMT

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