To check a categorical column with conditions

[Bu__]

Hi,

i want to create a dax query to calculate count of closed tickets, closed_successfully or closed_cancelled are two categories in ticket state

i want to check like

if(ticket state)=="Closed_Successfully" or if(ticket state)=="closed_cancelled":

then

closed_ticket=count(tickets)

how to write a dax expression to get number of closed tickets?

[andhiii079845 · Accepted solution]

MEASURE = COUNTX(FILTER(tickets,tickets[ticket state] IN {"Closed_Successfully", "closed_cancelled"}),"a column like ID")