Null Results in a Dimension - Selectable and Nameable

[ptl14495]

Hi, Good Afternoon

When building a dimension, i would like that the null results could have one name of my choice, and that these Null results could be selected.

the tests i made didn't work well but here is what i have tried,

If ( IsNull ( [Campo1]),'Sem informação', [Campo1] )

Thank you

Fernando Rodrigues

[sunny_talwar]

Why don't you perform this in the script?

If(IsNull([Campo1]), 'Sem informação', [Campo1]) as [Campo1]

[ptl14495]

Hello Sunny,

thank you for your fast response.

I am not confortable in doing this in the scrit.

I am doing this as a Dimension. Is it possible?

thank you

Kind Regards

Fernando Rodrigues

[jonathandienst]

>>and that these Null results could be selected.

If you don't do something like Sunny suggested (or NullasValue) in script, you will not be able to select the nulls, regardless of the how you calculate the dimension. Selections on a calculated dimensions are always applied to the underlying fields and you cannot select the nulls in the underlying.

[ptl14495]

OK.

Thank you both for your help.

Kind regards