Combining

[schoden]

Hi Community, 

I have a table : 

Unique ID with combination of name given to it.

I want to filter by unique name , that will show all ID it is given. One ID can  appear  twice in the name allocated to it.

I have attached the file. 

 https://netlinkgroup-my.sharepoint.com/:u:/g/personal/schoden_netlinkgroup_com_au/EWqOXLftsMhFq7iMOd...

For instance :

"a " is present in ID 1, 3, 4, 6, 7, 9, 10 

"b" is present in ID 1, 2, 3, 4, 5, 7, 8, 10 

Here ID 10 appears in "a" and "b"

When user filters "a", show all ID it belongs to 

When user filters "b", show all ID it belongs to

Thanks in advance 

[amitchandak · Accepted solution]

@schoden , I think better is you split by delimiter into rows

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

Find the file attached after signature

[schoden]

Thank you @amitchandak  I didnt realise we can split into rows....I did by Columns and Got more Confused> 

Thank You