I have three columns in a table that are containing employee names.
Is it possible to create a visualisation in Power Bi which would list all employees and count their appearance in those three columns? The real dataset contains 50+ names and 10k+ rows.
It is easy to so with one column but I could not figure out how to do it with more columns. Could anybody please point me to the right direction?
All the best,Verner
Go to Solution.
One of the options is to unpivot the columns.
Another is option is the following, where Table1 is the table you show
1. Create a one-column calculated table with the names of the employees:
ALL ( Table1[Calls] );
ALL ( Table1[Enquiries] );
ALL ( Table1[Meetings] )
2. Create these 3 measures:
COUNT ( Table1[Calls] );
TREATAS ( DISTINCT ( Employees[Name] ); Table1[Calls] )
COUNT ( Table1[Enquiries] );
TREATAS ( DISTINCT ( Employees[Name] ); Table1[Enquiries] )
COUNT ( Table1[Meetings] );
TREATAS ( DISTINCT ( Employees[Name] ); Table1[Meetings] )
3. Place Employees[Name] in the rows of a matrix visual and the three measures in values of the matrix
You can see it working here
Thank you @AlB for the straightforward and elegant solution. Much appriciated.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!