topic Null Results in a Dimension - Selectable and Nameable in App Development

Null Results in a Dimension - Selectable and Nameable

ptl14495 — Fri, 23 Mar 2018 16:28:02 GMT

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

Re: Null Results in a Dimension - Selectable and Nameable

sunny_talwar — Fri, 23 Mar 2018 16:41:31 GMT

Why don't you perform this in the script?

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

Re: Null Results in a Dimension - Selectable and Nameable

ptl14495 — Mon, 26 Mar 2018 07:47:15 GMT

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

Re: Null Results in a Dimension - Selectable and Nameable

jonathandienst — Mon, 26 Mar 2018 07:59:52 GMT

>>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.

Re: Null Results in a Dimension - Selectable and Nameable

ptl14495 — Mon, 26 Mar 2018 09:07:51 GMT

OK.

Thank you both for your help.

Kind regards