Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have Help desk tickets data having status description colmn.
I am trying to create cards using new column
Opened Tickets = IF((HD_Ticket[StatusDescription] <> "Closed") && (HD_Ticket[StatusDescription] <> "Duplicate"), 0, 1)
but its not working .
My requirement is Open tickets are the tickets that are not equal to closed , not equal to duplicate.
I want count for those tickets.
Is there is any way to do this?
Solved! Go to Solution.
This one worked for me
CuntDuplicate = CALCULATE( COUNTROWS (HD_Ticket), HD_Ticket[StatusDescription] = "Duplicate Entry" )
CuntnotClosed = CALCULATE( COUNTROWS (HD_Ticket), HD_Ticket[StatusDescription] <> "Closed" )
Opened = HD_Ticket[CuntnotClosed]-HD_Ticket[CuntDuplicate]
This one worked for me
CuntDuplicate = CALCULATE( COUNTROWS (HD_Ticket), HD_Ticket[StatusDescription] = "Duplicate Entry" )
CuntnotClosed = CALCULATE( COUNTROWS (HD_Ticket), HD_Ticket[StatusDescription] <> "Closed" )
Opened = HD_Ticket[CuntnotClosed]-HD_Ticket[CuntDuplicate]
Hi, @Sowjanya_09
If your problem has been solved, please accept the helpfu reply as solution to close this thread.
If you still need help, please share more details.
Best Regards,
Community Support Team _ Eason
If there is one row per ticket then use this solution
Open Tickets =
VAR mysubset = FILTER(HD_Ticket,
HD_Ticket[StatusDescription] <>"Closed") &&
(HD_Ticket[StatusDescription] <> "Duplicate")
RETURN
COUNTROWS(mysubset)
If there are multiple row per ticket then use this solution
Open Tickets =
VAR mysubset = FILTER(HD_Ticket,
HD_Ticket[StatusDescription] <>"Closed") &&
(HD_Ticket[StatusDescription] <> "Duplicate")
RETURN
CALCULATE(
DISTINCTCOUNT(HD_Ticket[ticketid]),
mysubset
)
I helped you so please kindley help me.
Click the thumbs up and Accept as Solution to leave kudos !
@Sowjanya_09 need more info about your data but just by looking at your code and the fact you are trying to create a measure let's try a quick win:
IF(SELECTEDVALUE(HD_Ticket[StatusDescription]) <> "Closed") && SELECTEDVALUE(HD_Ticket[StatusDescription]) <> "Duplicate"), 0, 1)
In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |