topic Re: Filter Data based on values starting with certain string in DAX Commands and Tips

Filter Data based on values starting with certain string

Anonymous — Thu, 20 Aug 2020 11:56:36 GMT

Hi! I want to ask if there is a way for me to filter the table below using DAX based on the Client IP address like the SQL query below:

select * from table

where Client IP like '%127%';

Thank you!

Greg_Deckler — Thu, 20 Aug 2020 11:58:38 GMT

Anonymous - You can, you would use SEARCH or FIND

You might want to create a "selector" like IF(SEARCH(...),1,0)

amitchandak — Thu, 20 Aug 2020 12:50:40 GMT

Anonymous , add a measure like this with other not summarized data

calculate(countrows(Table),containsstring(Table[Client IP],"127"))

other option

Anonymous — Thu, 20 Aug 2020 13:47:56 GMT

Thanks, amitchandak! Is there a way to just filter it? So it will still return other columns like email, browser, etc.

I tried adding a filter command but this error message showed:

"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."

Thank you!!

Anonymous — Thu, 20 Aug 2020 13:50:48 GMT

Hi Greg_Deckler - Thanks! I shall try this solution too.

I just wanted to filter those %% items and reflect the columns to my table.

Anonymous — Sat, 22 Aug 2020 13:00:53 GMT

This Solved my question. Thanks for your help!!