topic Re: Count rows based on multiple measures in DAX Commands and Tips

Count rows based on multiple measures

LABrowne — Wed, 08 Nov 2023 10:34:12 GMT

Hello,

I am trying to count the number of 'Hot Orders' where the following criteria below:

[SpicyLevel (%)] > 1 && [No. of Orders] >= 2 && TODAY() <= [Expiry Date Less 90 Days]

How do I combine the 3 conditions to count them?

Any advice much appreciated.

Kind regards,

Luke

ERD — Wed, 08 Nov 2023 10:39:21 GMT

Hi LABrowne , Calculate might help you.

your_measure = CALCULATE ( COUNT ( Table[Column] ), [SpicyLevel (%)] > 1, [No. of Orders] >= 2, TODAY () <= [Expiry Date Less 90 Days] )

LABrowne — Wed, 08 Nov 2023 10:57:38 GMT

Hi there,

Unfortunately I get the following error:

"A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed."

Dangar332 — Wed, 08 Nov 2023 11:15:26 GMT

this error occure when use measure as comparing value
try below code

CALCULATE ( COUNT ( Table[Column] ), filter('table',[SpicyLevel (%)] >1 &&[No. of Orders] >= 2 && TODAY () <= [Expiry Date Less 90 Days]) )

same problem solved
visit HERE