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 

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