DAX assistance

[Anonymous]

Hi, I am looking for help for a DAX function. I have a SL% where the formula is = 1-(x/y). When I do not have data for any month it still gives me 100% as SL% as I have 1 in numerator. How to build a foumula where if X and Y are missing for that month or day it should give me blank or let's say 0. Thank you in advance. Nancy

[Anonymous · Accepted solution]

Measure:=IF ( ISBLANK(Divide(x,y,blank()))
,Blank(),
1-Divide(x,y,blank())

I got in the habbit of always using the divide function to prevent unexpected results and reduce errors.  Hope this helps.

[Anonymous]

Many thanks Jason!!!!

It worked 🙂