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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy