Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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 |
---|---|
106 | |
101 | |
82 | |
79 | |
66 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |