Trying to show count of top 10 names from multiple columns

[A9kurs]

Hi Everyone,

I need your help , I am trying to show Top 10 names in power bi Vis, Names are in six column and i want to show which top 10 names appeared most in these 6 columns.   

Name 1	Name 2	Name 3	Name 4	Name 5	Name 6
A	E	B	A	E	J
B	C	A	D	A	A
E	A	B	C	B	D
C		A	B	V	A
D	D	L	K	V	A
M		L	K	V	A

These are Top names: 

A=10

B= 5

D= 4

C= 3

E= 3

 Appreciate your help. Thanks

[marcelsmaglhaes]

Hey @A9kurs !

You can merge the six columns into a single column using the "Unpivot Columns" feature. This will create a new column with the column names as a separate column, allowing you to easily count the number of occurrences of each name.

Best regards, 
Marcel

[AnkurSharma]

Hi Marcel,

Thanks for help,

I am trying to show Distinct names and there count of null.  If i do unpivot it gives distinct name but count i need is for next column of name. As shown in below example.

Name 1	Count Name 1	Name 2	Count Name 2	Name 3	Count Name 3
Abc	02/03/21	Def	null	Fgh	null
Def	02/03/21	Fgh	null	Abc	null
Abc	null	Xyz	Null	Abc	null
def	null	Abc	02/05/21	Fgh	02/05/21
Ghi	Null	Def	02/05/21	GhI	Null

I am trying to show names and there count of null

Abc    3

Def     2

GHI    2

XYZ    1