CSV values

[TootsiePatootsi]

Hi,

First of all thanks for reading this. I am new to PowerBI so I am hoping you could help me out.  I have the following data

#	Column Values
Request #1	A,B,C
Request #2	C,A

As you can see in the table above my column values is seperated  by a comma. What I wanted to achieve in my report is this.

PowerBI	Count
Selection A	2
Selection B	1
Selection C	2

I already tried the "Split column" features usinga delimiter, but when I use split into columns and use it in my report it did look great because somehow it looks like that data is not merging. When I tried to split into rows, it also affect my other column and duplicates it.

Thanks

[TootsiePatootsi]

Hi,

Thanks for the reply. I tried it out but somehow other data was also duplicated

#	Column	Other Columns
Request #1	A,B,C	Value 1
Request #2	C,A	Values 2

After splitting it my table turns into this which affects my other report:

#	Column	Other Columns
Request #1	A	Value 1
Request #1	B	Value 1
Request #1	C	Value 1
Request #2	C	Values 2
Request #2	A	Values 2