Count of name in multiple columns

[Hugo06]

Hi everyone,

I am a beginer in PowerBI and i struggle on the following point.

Here is an example of the data that I have :

Name 1	Name 2	Name 3
Jean	Peter
Peter	Jean
Daniel	Jean
Mike	Evan	Jean

I would like to count how many time each name appear in one of the 3 collumns and vizualize this in a pie chart.
On the exemple here, the result should be :

Jean : 4

Peter : 2

Daniel : 1

Mike : 1 

Evan : 1

Could you please help me to figured out how to do it with a measure ? 

Thanks in advance for your help.

[VilmarSch]

Uma alternativa seria transformar colunas em linhas no Power Query, depois uma medida dax

Contar = COUNT(Tabela1[Valor])

[pratyashasamal · Accepted solution]

Hi @Hugo06 ,
Select the three name columns and under the Transform tab select Unpivot Columns, Unpivot Only Selected Columns

right click on the value column and select Split Column, By Delimiter

split by comma and under the Advanced options choose Split into Rows

Trim the resulting value column (Transform -> Format -> Trim)

Filter out blanks from the value column .

You can now Close & Apply.
Now you can use COUNT and create visual out of this.

CountName = COUNT(NameTable[Value])

Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C