Exclude values from measure

[Anonymous]

Hi Experts

I want to amend my current measure to exclude the following codes.

From

=calculate ([quantity],

Filter(Customer Class, Customer Class [Segment] <> "106")

To exclude 

1008-0

1011-0

1011-1

1301-1

1301-2

1301-3

1301-4

From Segment column.

[Pragati11 · Accepted solution]

Hi @Anonymous ,

You can try modifying your DAX as follows:

CalculationsDax = 

CALCULATE ([quantity],

                    Filter(Customer Class, NOT(Customer Class [Segment])  IN { "1008-0", "1011-0", "1011-1", "1301-1", "1301-2", "1301-3", "1301-4" })

)

Thanks,

Pragati

[amitchandak]

@Anonymous , Try a measure like

calculate ([quantity], Filter('Customer Class', not('Customer Class'[Segment] in {"1008-0" ,"1011-0","1011-1","1301-1","1301-2","1301-3","1301-4" } )))