Filtering in calculation in Power BI

[Analitika]

Hello,

I would like to ask why filtering not working in my calculations? I used this measure:

It was not in {"Skola tiekeju"} but I still see skola tiekjui values in visual. Why it happens?

[Analitika]

_Gauta, EUR = 
CALCULATE(
    [__Lik_Suma]
    ,FILTER(
        _APV,
        (CONTAINSSTRING([apyvarta.operacija],"Pajamavimas") && not [apyvarta.operacija] in {"Turto pajamavimas"}  && [apyvarta.operacija] not in {"Skola tiekėjui"})
        || CONTAINSSTRING([apyvarta.operacija],"Gauta")
        || CONTAINSSTRING([apyvarta.operacija],"Pradinis")

    )
)

Hello,

Why I still getting included if I filtered not in ("skola tiekejui"). I use not in. But still it is in visual. How to resolve this?

[FarhanAhmed]

Since you are using || {OR} operater in your filter context. therefore your condition getting True for {"Skola tiekeju"} in values of  Operacija .

[Analitika]

So how to fix it because I need to exclude some data?

[FarhanAhmed]

try Use not in  expression of  {"Skola tiekeju"} with both || conditions 

||( Operacija  && not in  {"Skola tiekeju"})

||( Operacija  && not in  {"Skola tiekeju"})

[Analitika]

Error:

How to resolve this?

[FarhanAhmed]

sorry it was a typo

can you please add same condition with your next two filter expression of Operacija  

[FarhanAhmed]

can you please write you DAX code in text format here,

[Analitika]

_Gauta, EUR = 
CALCULATE(
    [__Lik_Suma]
    ,FILTER(
        _APV,
        (CONTAINSSTRING([apyvarta.operacija],"Pajamavimas") && not [apyvarta.operacija] in {"Turto pajamavimas"}  || not [apyvarta.operacija] in {"Skola tiekėjui"}  )
        || CONTAINSSTRING([apyvarta.operacija],"Gauta")
        || CONTAINSSTRING([apyvarta.operacija],"Pradinis")

    )
)

This also not works for me.

[Analitika]

_Gauta, EUR = 
CALCULATE(
    [__Lik_Suma]
    ,FILTER(
        _APV,
        (CONTAINSSTRING([apyvarta.operacija],"Pajamavimas") && not [apyvarta.operacija] in {"Turto pajamavimas"}  && [apyvarta.operacija] not in {"Skola tiekėjui"})
        || CONTAINSSTRING([apyvarta.operacija],"Gauta")
        || CONTAINSSTRING([apyvarta.operacija],"Pradinis")

    )
)