Filter with multiple conditions in a measure

[chavanr]

Hi there,

I am trying to create a measure with multiple conditions using filter.

so if the code is 214 then exclude products abc, xyz etc ( i need to exclude 10 products from the calculation)

CALCULATE(

    SUM(Facttable[sales]),

    FILTER(Facttable,Facttable[Type] ="Incoming"),

   FILTER(Facttable,Facttable[Code] ="214" && Facttable[productid] <> "abc" || Facttable[productid] <> "xyz" || Facttable[productid] <> "efg" || Facttable[productid] <> "lmn" || Facttable[productid] <> "jkl" || Facttable[productid] <> "uyt" || Facttable[productid] <> "erf" )

Here the && condition is not excluding the sales value from calculation,

Cheers,

[freginier]

You can do something like this to exclude several products

Measure = CALCULATE( COUNT('Table'[Column1]); NOT( 'Table'[Column1] ) in {"A";"B";"C"})

______________________________________________________

If you found this post helpful, please give Kudos C

[FreemanZ]

hi @chavanr

are you expecting something like:

Measure = 
CALCULATE(
    SUM(Facttable[sales]),
    FILTER(Facttable,Facttable[Type] ="Incoming")
) -
CALCULATE(
    SUM(Facttable[sales]),
    FILTER(Facttable,Facttable[Type] ="Incoming"),
    FILTER(Facttable,Facttable[Code] ="214" 
)

[chavanr]

Hi @FreemanZ  Thanks for your response 

nope, i need to include but only exclude some item from that code.

e.g. there are 20 items & want to exculde 5 from them.