Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |