Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have data that shows help desk tickets. Each ticket has multiple actions which is stored in a table called "Actions" where it lists every action taken within the ticket. One column is "IsAuto" and if there is a -1 it means it is an auto generated action and if it is a 0 then it is not automated action.
I need to find a way to say "IF ALL Actions on a Help desk tickets are automated (=-1), then "automated ticket" else "Not automated ticket"
Hi @bhmiller89,
Could you please mark the proper answers as solutions?
Best Regards,
Dale
May be something clever, thinking loud here. Do sum of all automated IsAuto value of each action of a ticket, and also do the count of actions, if abs(sum) = count of actions it means all tickets were -1 and that means it is "automated ticket".
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
It didn't work as a column but it rendered properly as a measure:
SelfHealed = IF(DISTINCTCOUNT('dpmgr tblHDActions'[ActionID])=[abssum], "Self Healed", "Not Self Healed")
However, I need to use "Self Healed" vs "Not Self Healed" as a slicer, which I can't do with a measure (to my knowledge)
For a calculated column, something like this should work.
By the way I'm inferring column/table names from your earlier post and guessing there's a TicketID. Please change as needed.
SelfHealed = IF ( CALCULATE ( SELECTEDVALUE ( 'dpmgr tblHDActions'[ActionID] ), ALLEXCEPT ( 'dpmgr tblHDActions', 'dpmgr tblHDActions'[TicketID] ) ) = -1, "Self Healed", "Not Self Healed" )
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |