Forum Discussion
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 end goal is to have a visual that shows the ratio of RMA Raised to Resolved, the only two different ways a ticket can be closed. Therefore, I need a column that is purely Resolved or RMA Raised, and a 0 where Open should be. Hopefully, this will be ignored, and the visual will only have the two outcomes.
As an example, below is a screenshot with all three Status options, but ideally I would like to ignore the Open status tickets.
Thanks!
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.
3 Replies
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
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.
