Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
MEASURE = COUNTX(FILTER(tickets,tickets[ticket state] IN {"Closed_Successfully", "closed_cancelled"}),"a column like ID")
Proud to be a Super User!
MEASURE = COUNTX(FILTER(tickets,tickets[ticket state] IN {"Closed_Successfully", "closed_cancelled"}),"a column like ID")
Proud to be a Super User!
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
23 | |
22 |