Using an IF statement to detect 0's as Denominators in DAX to remove false 100%'s

[Karolina411]

Hello Super Users:

I've a problem I cannot seem to solve:

I have data like this: Note that there is a denomintor in week 1/7/2023 that is returning 100%

as the DENOMINATOR IS 0 (the % is from a MEASURE: 

%Avail2Schedule = (DIVIDE([BHSschedOpenings],[BHSAvailHrs],0))

How can I add an IF statement or Coalesce to show a 0% on a MEASURE??  It seems so simple but I have already tried a few things like IF (divide([BHSschedOpenings],[BHSAvailHrs] = 0, Blank(), DIVIDE ([BHSschedOpenings],[BHSAvailHrs])) but it does not work.

[Anonymous]

Hi @Karolina411,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng