How to ignore empty strings with "Advanced filtering"

[pavel_severov]

Dear experts,

Please explain how to ignore empty strings with "Advanced filtering" for the table like below.
I.e. this filtering must select 1st and 3rd rows, and ignore the 2nd.

Table = DataTable("Name", STRING, "Value", STRING ,{

{"Text","Some text..."},

{"Empty String",""},

{"BLANK()",BLANK()}

})

UPDATE: The question is about impossibility to ignore empty strings in the right-side filters, even with Filter type = Advanced filtering.

[pavel_severov]

@Fowmy
It's a pitty, I guessed it... Thanks for the confirmation!
Is it really solution? 🙂 Nevertheless, will accept it.

[Fowmy · Accepted solution]

@pavel_severov 

It is not possible to do so with the filter filter pane. 

You can replace the empty with null in power query so that you will only see Blanks which you can filter in the Filter Pane

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[pavel_severov]

Hi @CNENFRNL , @Fowmy ,

Thank you for valuable suggestions!
But problem is not in DAX - I see no possibility to ignore empty strings in the right-side filters, even with Filter type = Advanced filtering.
Do you maybe have an ideas - how to overcome it?

[Fowmy]

@pavel_severov 

I agree on == with @CNENFRNL .

Please try the table below:

TableFiltered = 

var __t = 

DataTable(
    "Name", STRING, "Value", STRING ,
    {
        {"Text","Some text..."},
        {"Empty String",""},
        {"BLANK()",BLANK()}
    }
)

return

FILTER(
    __t,
    NOT [Value] == ""
)

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[CNENFRNL]

Hi, @pavel_severov , you might want to apply “strictly equal to” operator (==, not a emoji here 😂) to such a case. For example,

Exclude Empty String = 
CONCATENATEX (
    FILTER ( 'Table', NOT ( 'Table'[Value] == "" ) ),
    'Table'[Name],
    UNICHAR ( 10 )
)

 by the way, the usual "not equal to" operator isn't a "strict" one, it treats both BLANK() and "" as the same.