Forum Discussion

LABrowne's avatar
LABrowne
Helper II
2 years ago
Solved

Count rows based on multiple measures

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 ...
  • Dangar332's avatar
    Dangar332
    2 years ago

    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 

     

ERD's avatar
ERD
Community Champion
2 years ago

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's avatar
LABrowne
Helper II
2 years ago

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's avatar
    Dangar332
    Resident Rockstar
    2 years ago

    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