Power bi cannot distinguish zero and null

[wchiu]

Hi Guys, 

I have a column that have value null,0,1,2,3,4,5   in a SQL table. 

When I am using this column in Power BI , I can see the filter plane have value (blank,0,1,2,3,4,5). 

However, when I filtered this column to zero , Power BI will always return the union result 0 and blank. 

I have done some research on this topic and I know Power BI had some issue with zero , blank and null. 

Moeroever, I have lots of column in similar situation ,I don't really want to add any extra column or measure to enable this basic feature. 

Do you guys have any idea?

[amitchandak]

@wchiu , Not very clear.

In DAX you can check isblank([Column/meausre])  for blank

in Power query  you can check

if [col] =null then

[wchiu]

Let me assume like this, I have a table like below 

When I filtered this value to 0 , blank is also present in the value 

I only want 0 appears in my table.....

[amitchandak · Accepted solution]

@wchiu , Can add filter once more and remove is blank and check if it works

[wchiu]

Thanks mate! It works!!!!!!!!!