Value Count after Unpivot Columns is not unique

[TinyElephant]

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

[Anonymous · Accepted solution]

Hi @TinyElephant ,

Step1: unpivot the year columns.

Step2: filter experience column which value is blank.

Step3: unpivot the software columns.

Pbix as attached.

Best regards,

Jay

[TinyElephant]

Thanks. Any suggestions for the case when I have multiple such unpivoted headers and their values?

[TinyElephant]

Any other way to represent the excel data would also be fine. 

[Greg_Deckler]

@TinyElephant You can use:

Count Measure = COUNTROWS(DISTINCT('Table'[Employee]))

[TinyElephant]

@GregNow the percentage is incorrect. I'll figure out a way to attach .pbix file

[TinyElephant]

@Greg_Deckler 

Attached a drive link to the Power BI file
https://drive.google.com/file/d/1ksOVue1bx8eyCCDSnKQuPMJDshnch7kK/view?usp=sharing