Forum Discussion

adavid999's avatar
adavid999
Helper V
4 years ago

dax NOT in

Helllo,  rather than writing out all this in example 1 (which gives correct result), how do I specify the NOT in (i want to count everything in table[sport] column except "09" and "99"   1. this g...
Need Help
ryan_mayu's avatar
ryan_mayu
Super User
4 years ago

adavid999 

maybe you can try this

test3 = 
    CALCULATE(count(table[sport]), 
    (table[sport] <> "09"||
    table[sport] <> "99" &&
    table[year] = "2017/18")
adavid999's avatar
adavid999
Helper V
4 years ago

hi ryan_mayu no this did not work. Your suggestion...

test3 = 
    CALCULATE(count(table[sport]), 
    (table[sport] <> "09"||
    table[sport] <> "99" &&
    table[year] = "2017/18")

 gives a different result to this (which gives the result I expect)

 

my measure = 
    CALCULATE(count(table[sport]), 
    table[sport] in {"01","02","03","04","05","06","07","08","10","11","12"},
    table[year] = "2017/18")

I want to count values that are not "09" or "99" from available values that are:

"01","02","03","04","05","06","07","08","09","10","11","12","99"

 grateful for any help with this.