Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Multiples Filters DAX

Hi people.
Can anybody help me? Starting from the example below, which formula I could use to obtain the following result: I want to filter the opportunities that have the Status "Lost", that have the score "3" and "4", Blacklist "Não" and "Cell blank".

 

Thanks

Karina

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Create a measure like this and plot that with ID in the visual

     


    calculate(count(Table[ID]), filter(Table, Table[Score] in {3,4} && ( Table[Blacklist] = "Não" || isblank(Table[Blacklist] ))))

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      amitchandak It worket.

       

      Thank you so much.