Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Exclude values from measure

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.

Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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" } )))

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    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