Forum Discussion
New Column - Filter with just unique values
Hey all, It seems like I've done the hard part with this new column, I have a Users Table, which contains a column containing Groups it belongs to, as well as Department of the Users. The Group Tabl...
Anonymous , One way, is to split columns into rows groups of table User
then you can try
Concatenatx(Table, Table[Department], ", ")
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag
Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24
One more way is, again try the same measure as above
Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c