To check a categorical column with conditions

Bu__ — Mon, 13 Mar 2023 09:56:34 GMT

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?

Re: To check a categorical column with conditions

andhiii079845 — Mon, 13 Mar 2023 10:16:34 GMT

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