SQL NULL

[schoden]

Hi All, 

I want to filter name by %mas% OR NULL 

My Dax is : 

Column = IF( CONTAINSTRINGS(name),"mas" || name= Blank(), 1, 0)

But it is not filtering correctly, any idea?

[az38 · Accepted solution]

Hi @schoden 

try

Column = IF( CONTAINSTRINGS([name],"mas") || ISBLANK([name]), 1, 0)

[schoden]

@az38  Hi Thanks for the response..... 

The code got me closer to the actual number , the difference is less  atleast 😄 

[az38]

@schoden 

sometimes it happens that blank is not exactly blank, so try to compare with empty string:

Column = IF( CONTAINSTRINGS([name],"mas") || ISBLANK([name]) || [name]=""), 1, 0)

[schoden]

@az38 

It works the same, same ouput.

Thanks though 

[az38]

@schoden 

can you show example of row with incorrect result?

[schoden]

@az38  Hi the green table is the actual table , the second table is from my power BI , power BI doesnt show/pick the blank row as seen in green table which is $528..

[az38]

@schoden 

Have you set "Show items with no data" as active for the left column in visual?

[schoden]

@az38  How can I set that ? , show item with no data in power BI 

[az38]

@schoden 

https://docs.microsoft.com/en-us/power-bi/desktop-show-items-no-data

maybe it will help you