Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
4 years ago

Filtering in calculation in Power BI

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...
Need Help
FarhanAhmed's avatar
FarhanAhmed
Community Champion
4 years ago

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

 

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

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

Analitika's avatar
Analitika
Post Prodigy
4 years ago

Error:

How to resolve this?

  • FarhanAhmed's avatar
    FarhanAhmed
    Community Champion
    4 years ago

    sorry it was a typo

     

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

    • FarhanAhmed's avatar
      FarhanAhmed
      Community Champion
      4 years ago

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

      • Analitika's avatar
        Analitika
        Post Prodigy
        4 years ago
        _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")

    )
)