How to create a pivot from 2 columns (source table) - note attached screenshot

[pmazara]

Trying to create a pivot from 2 columns (from source table) -> note that the second column has repeat enteries

Need to DistinctCount the skill type against each user so as to create a pivot per custom Table 2 

This is to satisfy the data format required for the venn visual

[amitchandak]

One is that you use matrix visual and drag one on row and another on the column. Drag one of these again in values and take count.

You want change the table structure

https://radacad.com/pivot-and-unpivot-with-power-bi

[Anonymous · Accepted solution]

Hi there - 

I have tried using the sample data attached in your screenshot and tried to get the output you were looking for. Please find the file uploaded here - https://drive.google.com/file/d/1nVIXsZaHUkOsB4_S3kex9_pVuE7QNvD6/view?usp=sharing

Once accessed, please let me know so that I can delete the file from there. If the above solution helped you, please accept this as a solution.

Regards

E

[pmazara]

Hi E @Anonymous,

This is great. Just need your help with one more step to complete the solution -> how to get distinct count for each skill type ?

The Venn visual only works with binary values

Thanks,