August 27, 2020 at 2:03 pm
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
August 27, 2020 at 2:23 pm
FILTER(<tableObject>, ISNONBLANK([Column]) )?
August 27, 2020 at 2:53 pm
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.
August 27, 2020 at 4:25 pm
Use ISBLANK([ColumnWithNulls],"AlternativeValue")
ISBLANK is analogous to T-SQL ISNULL()
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply