Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I've 10 different tickect types and I'm trying to not count three of them to find the total pending tickets. The status I'm trying to ignore are "Closed, Resolved, Resolved - Self Heal" and the additional condition I'm trying to use is that "Resolution SLA Met = NO".
Any help on this would be appriciated.
Solved! Go to Solution.
Hi @Anonymous ,
I don't know how your data strutcture looks like but you can give a shot with these below formulas:
You can either create a DAX measure something like this and put it in a visual Level filtes and apply filter "is blank"
DAX Measure = Var _status=SELECTEDVALUE(Sheet1[status]) return If( _status ="Closed" || _status ="Resolved" || _status ="Resolved-Self Heal"
,1,blank())
Or a Dax Column like this and put it in a Page level filter /Visual Level filter and apply filter to show Blank
DAX Column = If(Sheet1[status] ="Closed" || Sheet1[status] ="Resolved" || Sheet1[status] ="Resolved-Self Heal" ,1,blank())
Let me know if this works.
Thanks,
Tejaswi
Hi @Anonymous ,
I don't know how your data strutcture looks like but you can give a shot with these below formulas:
You can either create a DAX measure something like this and put it in a visual Level filtes and apply filter "is blank"
DAX Measure = Var _status=SELECTEDVALUE(Sheet1[status]) return If( _status ="Closed" || _status ="Resolved" || _status ="Resolved-Self Heal"
,1,blank())
Or a Dax Column like this and put it in a Page level filter /Visual Level filter and apply filter to show Blank
DAX Column = If(Sheet1[status] ="Closed" || Sheet1[status] ="Resolved" || Sheet1[status] ="Resolved-Self Heal" ,1,blank())
Let me know if this works.
Thanks,
Tejaswi
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |