SUMX and COUNTAX Zeros

[Anonymous]

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! 

[MFelix · Accepted 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)

[Anonymous]

Hi @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. 🙂