Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

SUMX and COUNTAX Zeros

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])

aaragon0902_2-1675809020064.png

 

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! 

 

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

2 REPLIES 2
MFelix
Super User
Super User

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

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

 

aaragon0902_0-1675872634494.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.