Why is there still null values?

[AndreasMoller]

Hello,

I have a problem with null value.

I'm using a pivot table and the dimension "q_produktklass" having some null values.
To make the null value be sorting last i was using this formula:

=if(isnull(q_produktklass), 'Värde saknas', q_produktklass)

But as you can see at the picture there is still some null values. Can anyone help me understand why? 
If i go to the dimension and uncheck "Include null values" they disappear. But i dont want to do that. 

[Lakshmanan]

Also make sure , There are no Blanks in the field.

[Mark_Little]

You are only checking your first field is null, Check for Null values in the second field. 

[Or · Accepted solution]

This is typically a result of a data schema join with missing values.

Consider:

Load * INLINE [
A, B
1, 2
4, 5
7, 8
];

Load * INLINE [
B, C
2, 100
8, 200
];

In this scenario, C isn't null, it's outright missing for the combination of A and B {4,5}.

[AndreasMoller]

Thanks, but it's the same if I remove the other dimensions and only got "q_produktklass" left. 

[AndreasMoller]

I have tried that already, but i got the same result. 

[AndreasMoller]

Yes that may be it, can i enter a value in that "missing" value? 

[Or]

The best approach would be to fix the data by filling in the missing values.

I think you can work around this by using Aggr(), something like:

=if(isnull(Aggr(Only(C),C)),'ZZ',C)

But this is pretty ugly and may cause performance issues in some cases.