NaN to replace with 0

[harirao]

Hi All,
Required your help, i have created a Measure included ISBLANK function still getting "NaN" for few rows, below dax and snapshot for your reference.

TEST % =

if(isblank(DISTINCTCOUNT(RawData[Opportunity ID])),0,DISTINCTCOUNT(RawData[Opportunity ID])) /

if(ISBLANK(calculate(SUMX(VALUES(RawData[Status_New]), (RawData[DISTINCTCOUNT])), ALLSELECTED(RawData[Status_New]))),0,

calculate(SUMX(VALUES(RawData[Status_New]), (RawData[DISTINCTCOUNT])), ALLSELECTED(RawData[Status_New])))


Required your assistance to solve this error.

Thank you

Regards,
Hari

[ValtteriN · Accepted solution]

Hi,

You can use IFERROR to get around this. So IFERROR([Measure],0)

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!