Forum Discussion

LABrowne's avatar
LABrowne
Icon for Helper II rankHelper 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
Icon for Community Champion rankCommunity 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
    Icon for Helper II rankHelper 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
      Icon for Resident Rockstar rankResident 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