Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm trying to get consistent blank or zeros in the matrix below. As shown below, # SLA Met, # SLA Breach show zeros but Excep shows blanks.
Below are the measures I am using:
# SLA Met=
SUMX(task_sla,[RAW - Count SLA Met] + [Breach Exceptions])
# SLA Breach=
SUMX(task_sla,[RAW - Count SLA Breach]) - SUMX(task_sla,[Breach Exceptions])
Excep= COUNTAX(task_sla,task_sla[dv_u_breach_code])
I would like to show zeros in the Excep column where there are blanks. I have tried adding + 0 at the end but then it shows ALL Region/SLA/INC#, even those that have zero # SLA Met and # SLA Breach.
So really, I'd like to show zeros instead of in the Excep columns only if # SLA Met or # SLA Breach have values.
Hope that makes sense. If anyone can assit I'd be greatly appreciative.
Thanks!
Solved! Go to Solution.
Hi @Anonymous ,
Try the following code:
Excep= IF( [# SLA Met] <> Blank() || [# SLA Breach] <> Blank() ,COUNTAX(task_sla,task_sla[dv_u_breach_code])+ 0)
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
Try the following code:
Excep= IF( [# SLA Met] <> Blank() || [# SLA Breach] <> Blank() ,COUNTAX(task_sla,task_sla[dv_u_breach_code])+ 0)
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix ,
This measure worked perfectly for me, thank you!!
I haven't used IF statement very much in DAX, this is great to have in the back pocket. 🙂
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 |
---|---|
105 | |
101 | |
81 | |
79 | |
67 |
User | Count |
---|---|
122 | |
110 | |
94 | |
82 | |
77 |