Set Analysis ISNULL or (has a particular value )

[prananellutla]

Hi I want to include dimenstion= null or dimension=certain value in a set analysis caculation.

Iam using ( sum( {$<[dim]={1},[dim2]={'V1','V2'}>} if(IsNull([Dimenstion])0,1 or if(dimention='value3') in a set analysis.I need to show total =11 in this set analysis

[MatheusC]

Hi, @prananellutla 
you can use the *All* function

[prananellutla]

@MatheusC I just want to pick value 3 and nulls, there are other values in the dimension .

[MatheusC]

Hi, @prananellutla 

I think I still don't quite understand the need,

if you only need the null and then add it to the value3

Count(distinct{$-<Dimension={"*"}>}value) - taking only null value

Or if that's not it yet. I leave space for other specialists and Masters who can understand and help you.

[marcus_sommer]

NULL isn't stored anywhere and therefore it couldn't be directly shown or selected or calculated. The most common approach for such scenarios is to fetch NULL within the data-model with NULL variables or logic like: if(len(trim(Field)), Field, '<NULL>') and assigning a real value for it. This one could then simply queried like you want.