Forum Discussion

OsmanEmi's avatar
OsmanEmi
Frequent Visitor
5 years ago
Solved

Filtering error based on two columns

Hi,   I have the below dax expression and am trying to filter based on two rows however I get an error with the second filter that states "A Function Filter has been used in a true or false expres...
Need Help
  • timg's avatar
    timg
    5 years ago

    Hi OsmanEmi,

    could you change the && to , and try again?

     

    -Crew NA. = CALCULATE(COUNT(FACT_DELIVERY[CREW_QTY]),
FILTER(ALL(FACT_DELIVERY[CREW_QTY]),FACT_DELIVERY[CREW_QTY]<2)
,
FILTER(ALL(FACT_DELIVERY[STOP_TYPE]),FACT_DELIVERY[STOP_TYPE] <> "C"))

     

    The && function returns a TRUE or FALSE based on whether the conditions are met. by using the "," instead you are adding another filter to your calculate function, instead of turning it into a TRUE/FALSE.

     

    Best regards,

    Tim 

timg's avatar
timg
Solution Sage
5 years ago

Hi OsmanEmi,

could you change the && to , and try again?

 

-Crew NA. = CALCULATE(COUNT(FACT_DELIVERY[CREW_QTY]),
FILTER(ALL(FACT_DELIVERY[CREW_QTY]),FACT_DELIVERY[CREW_QTY]<2)
,
FILTER(ALL(FACT_DELIVERY[STOP_TYPE]),FACT_DELIVERY[STOP_TYPE] <> "C"))

 

The && function returns a TRUE or FALSE based on whether the conditions are met. by using the "," instead you are adding another filter to your calculate function, instead of turning it into a TRUE/FALSE.

 

Best regards,

Tim 

  • OsmanEmi's avatar
    OsmanEmi
    Frequent Visitor
    5 years ago

    Hi timg,

    This worked thank you very much.
    Is it possible to explain why this worked as opposed to my method?

    • timg's avatar
      timg
      Solution Sage
      5 years ago

      Hi Osman,

      I included an explanation as an edit in my first reply just now. Does this clarify the difference sufficiently?

      Best regards,

      Tim