Get all rows where value is in a column

[Anonymous]

Hi,

Is there any way in Power BI where I can pull all the rows in a table where a value is in a column? I need to use RLS, but the issue is that I have multiple columns with names. I figured a search in a concat column would work, but don't know if there's a dax formula that works this out. 

The output I would need a table ideally in this format so I can apply RLS to the 'Name' column.

[ERD]

@Anonymous , you can achieve this result in Power Query. Choose columns with names, click Transform tab - Unpivot columns.

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.