replace blanks with 0

[sinanalmac]

Hi All,
I'm trying to replace 0 value  if the column  value is blank 

here is my  formula 

Measure = IF(DISTINCTCOUNT(HRBC[ID])=BLANK(),"Black",DISTINCTCOUNT(HRBC[ID]))

This formula helps me with the other reports. I always use this formula. 

But this time it wasn't worked how can I  solve this problem. 

Thank you

[Shishir22]

Hello @sinanalmac ,

Please try using ISBLANK function.

NewMeasure = IF(ISBLANK([YourMeasure]),0,[YourMeasure])

IF this solves the requirement, please accept it as a solution. Kudos are also appreciated!

Thanks

[sinanalmac]

hello @Shishir22 , it didn't work too

[Shishir22 · Accepted solution]

Hello @sinanalmac ,

Can you please try creating table of Department which will contain DistinctValue of Department.

Give relationship of Department table to HRBC table on departmentname.

Pull Department from dimension table in visual and same measure.

IF this solves the requirement, please accept it as a solution. Kudos are also appreciated!

Thanks!

[sinanalmac]

Yes . It's done. Thank you for the solution @Shishir22 

[PaulDBrown]

@sinanalmac  just add a + 0 to your measure

[sinanalmac]

it didn't work. I have tried it.