Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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. 🙂
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |