Multiple records in the same column

[Syndicate_Admin]

Good, in the situation shown and for a visualization 'Graph of 100% stacked bars' representing on the X Axis the count of Column 2.

Is it possible that record No. 4 can be viewed as the count of 1 John and 1 Separate Antony?

The solution of separating the record into 2 rows leaving row 4 (4 / John / B) and also creating a new row with: (5 / Antonio / B) is not valid for me.

Column 1	Column 2	Column N
1	David	A
2	Juan	B
3	Antonio	C
4	Juan, Antonio	B

Thank you!

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,

If you separate names by "," in column2, you can try this measure to count names in column2.

Count of Name = 
LEN ( MAX ( 'Table'[Column 2] ) )
    - LEN ( SUBSTITUTE ( MAX ( 'Table'[Column 2] ), ",", "" ) ) + 1

 Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

No, not possible.