Forum Discussion
Solved
Filter the reverse in DAX
Hello, I have a column in Power BI (for a ticketing system) called Status, which is quite simply the status of each ticket. There are three options this can be: Open, Resolved and RMA Raised. The...
Hi pete1234 ,
In order to ignore the Open status tickets ,
you can just apply visual level filter of status column on your visual and select all options except Open status.
I am not sure if I understand it correctly, but you could either simply use a filter on the visual to filter out "closed" or create a measure counting the tickets CALCULATE(COUNT(Ticket[id]),Ticket[stus] <> "closed") and use it in the visual.
But closed can be represented as either RMA Raised or Resolved