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 

     

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