Creating a new table from columns in an existing table with only rows that contain specific text

[TPB_Paul]

I have treid in vain to create a new table that only has some of the rows in the original and would appreciate some help.

I have a table called 'Stuff'.  It has many columns and a lot of rows.  I want to create a new table called 'SomeStuff' that only has the rows who's column 'strategies' contains the phrase 'Technology-'.

I have tried using CONTAINS and IF and FILTER and have no success.  

The corrext DAX would be greatly appreciated.

[Zubair_Muhammad · Accepted solution]

Hi @TPB_Paul

You can create a new Calculated Table as follows

Go to Modelling Tab>> New Table

New Table =
FILTER (
    ADDCOLUMNS ( stuff, "Check", FIND ( "Technology-", Stuff[Strategies],, 0 ) ),
    [Check] > 0
)

Also you can add a calculated Column and filter the results using this column

Column =
FIND ( "Technology-", Stuff[Strategies],, 0 )

[TPB_Paul]

This was a great help for usin g the FIND.  However my main problem is the fact that PowerBI does not save the settings for a filter and I need that functionality so that each department only sees their data.  If I could combine FIND and FILTER I could solve the problem.  If I have a column named DEPT, and out of all the departments I want to filter 'SPORTS', is there a way I could create a column that would act as a filter to only show data for the SPORTS department?

This would solve all my filtering problems until there is a way to save default filtering in a report.

[TPB_Paul]

Worked great.  Thanks so much !!