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