Issue with NULL/Blank records

[#1]

I am encountering a strange problem with NULL/Blanks in my dimension data.

I have multiple records in my data set for each dimension value and I am summing up the mesasures against it. I have sorted the dimension based on sum of 1st measure column.

If you see the screenshot 1, the last record is null and there is no record for ELMIRA,NY even though there is data.

When I change the dataset and replace all nulls with 'BLANK', I get the entire data. Please see screenshot 2

This is affecting the totals as well. Please advise how to rectify this or handle nulls.

[#2]

I found the problem, I was restricting the list to Count(Distinct <Dim>).

Since there is a null value, it was restricting one record less as per my requirement.