Solved: Count rows based on multiple measures

LABrowne · ‎11-08-2023

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

Dangar332 · ‎11-08-2023

HI, @LABrowne

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

View solution in original post

ERD · ‎11-08-2023

Hi @LABrowne , Calculate might help you.

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

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.

Check out my latest demo report in the data story gallery.

Stand with Ukraine!

Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!

LABrowne · ‎11-08-2023

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 · ‎11-08-2023

HI, @LABrowne

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