DAX with Tabular Model Series | How to find multiple string in a tabular table using DAX?

Today let’s discuss how we can find multiple strings in a tabular model using DAX language. For this we need to use FIND function with CalculateTable or || with Filter. Well both filter and calculateTable are used like where clause in SQL Server. Now lets go through an example to discuss the same in more detail

Ok so in the above example we are selecting types and description column from Internet Sales table. Please note that we are selecting distinct data only. Basically Summarize works like that. It will always gives distinct values. Calculate table is used to filter out things like where clause works in SQL Server. Here we have applied multiple filters.

Now point to be noted is how Filter function os used to find multiple strings from a single description column. Here we will get all the rows where column value matches with any of the value given in the string.

Now let’s consider one more query where we are finding multiple strings