SSRS DAX Replace NULL Values

• jorgesam

  SSC Enthusiast

  Points: 173

  More actions

  August 27, 2020 at 2:03 pm

  #3784133

  Hi,

  I've been trying to solve this for some time now, but nothing worked, and couldn't find any specific help online.

  I have a report built in SSRS using DAX, and I'm having multi valued parameters.

  In order to feed each parameter I have a separate dataset for each, and in this example I will show the Item Category

   

  EVALUATE SUMMARIZECOLUMNS ('Item'[Category]

  )

  ORDER BY 'Item'[Category] ASC

   

  But the dataset includes the null value, which doesn't allow me to have all the values selected, and also I can't allow null values in multi value parameters.

  So what I'm asking is how can I use a similar function to the isnull(,) from SQL?

  I basically want to say isnull(Item Category,'Unknown')

  Thanks

• pietlinden

  SSC Guru

  Points: 63584

  More actions

  Follow

  August 27, 2020 at 2:23 pm

  #3784139

  FILTER(<tableObject>, ISNONBLANK([Column]) )?

• jorgesam

  SSC Enthusiast

  Points: 173

  More actions

  August 27, 2020 at 2:53 pm

  #3784153

  I've tried the below

  EVALUATE SUMMARIZECOLUMNS ('Item'[Category],

  FILTER(

  VALUES ('Item'[Category]),

  ('Item'[Category] <> BLANK ()

  )

  )

  )

  ORDER BY 'Item'[Category] ASC

  But I don't want to filter out the null values, I want to replace them, because If I filter them out then the end result is not correct, data is missing.

• pietlinden

  SSC Guru

  Points: 63584

  More actions

  Follow

  August 27, 2020 at 4:25 pm

  #3784177

  Use ISBLANK([ColumnWithNulls],"AlternativeValue")

  ISBLANK is analogous to T-SQL ISNULL()