Forum Discussion

adavid999's avatar
adavid999
Icon for Helper V rankHelper 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
Icon for Community Champion rankCommunity 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
    Icon for Helper V rankHelper 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
      Icon for Community Champion rankCommunity Champion
      4 years ago

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