Advanced Filtering and Relationships

[marehmat]

I recently began learning PowerBI and would love some help with this. I have data in the following format. Field 3 is a column with semicolon seperated values.

Field 1	Field 2	Field 3
A	1	AB; AC;AD
B	2	AB; AD
C	3	AD

I aim to do two things

1a- Get Unique Values from Field 3 i.e.

AB

AC

AD

1b- Get a count of their occurance

AB	2
AC	1
AD	3

2- When making visualizations from these tables, the relationship exists i.e. when I select AB from 1b; it highlights A and B rows from the parent table or visualizations connected to those. 

Any help would be helpful.

[Eric_Zhang]

@marehmat

The first thing is to re-model the data by spiliting and unpivot columns.

[marehmat]

@Eric_ZhangThis is nice! Definately something I can use. Thanks!! Any insight on how I may use this new Table to create relationships with the parent table and visualizations derived from it?

[marehmat]

I recently began learning PowerBI and would love some help with this. I have data in the following format. Field 3 is a column with semicolon seperated values.

Field 1	Field 2	Field 3
A	1	AB; AC;AD
B	2	AB; AD
C	3	AD

I aim to do two things

1a- Get Unique Values from Field 3 i.e.

AB

AC

AD

1b- Get a count of their occurance

AB	2
AC	1
AD	3

2- When making visualizations from these tables, the relationship exists i.e. when I select AB from 1b; it highlights A and B rows from the parent table or visualizations connected to those. 

Any help would be helpful.