How to display blank values?

[vanand3535]

I have some columns in the dimension.

In that dimension there some values along with the null values.

for example --

dimension ---country

there is  5 country along with two bank values

then

in the measure by expression i want to display total number of country as 7(5values+ two blank values) not 5 only

How can I display the blank values?

[agigliotti]

if you mean null values you have to check "Include null values" under dimension.

[vanand3535]

I tried but it's not working

[agigliotti]

did you also check the option "Include zero values" under Add-ons->Data handling ?

[vanand3535]

yes,but nothing happened

[agigliotti]

what's your measure expression ?

please send a screenshot to understand more.

[vanand3535 · Accepted solution]

I tried this:-

In data load editior:-

If(len(Trim(Play_Active_Type))=0,1,Play_Active_Type) as flag

In expression :-

Flag={'1','unknown','other:specify'}

it's working fine.