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

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

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,