Forum Discussion
Value Count after Unpivot Columns is not unique
I have some employee data in Excel table containing experience and software skills. I applied Unpivot Columns of both Experience and Software Skills separately and plotted them. The percentage/proportion is coming out correct but the count is exaggerated. Please suggest.
| Employee | 1-3 years | 4-8 years | 9+ years | Software 1 | Software 2 | Software 3 |
| John | Y | Y | Y | |||
| Derek | Y | Y | Y | |||
| Michael | Y | |||||
| William | Y | Y | Y | Y |
6 Replies
- Greg_Deckler
Community Champion
Anonymous You can use:
Count Measure = COUNTROWS(DISTINCT('Table'[Employee]))Attached a drive link to the Power BI file
https://drive.google.com/file/d/1ksOVue1bx8eyCCDSnKQuPMJDshnch7kK/view?usp=sharing
