Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
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
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,
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |