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
Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi adavid999 ,

 

Can you try this:-

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

 

Thanks,

Samarth

adavid999's avatar
adavid999
Helper V
4 years ago

Samarth_18 I tried but this didn't give me the result I was expecting

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    4 years ago

    adavid999 , Can you please share your PBIX after removing sensitive data and also the expected output?