Forum Discussion

sinanalmac's avatar
sinanalmac
Resolver I
5 years ago
Solved

replace blanks with 0

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
Need Help
Show and Tell
Tips and Tricks
  • Shishir22's avatar
    Shishir22
    5 years ago

    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!

6 Replies

  • Shishir22's avatar
    Shishir22
    Solution Sage
    5 years ago

    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

      • Shishir22's avatar
        Shishir22
        Solution Sage
        5 years ago

        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!