Calculating % from Unpivoted Data

Question

Hi all,&nbsp;I'm pulling together survey responses, a number of questions are a Yes/No response and I have data from the previous year that I'd like to compare to. I managed to convert the number of responses into a % using the following DAX...&nbsp;Yes/No % =VAR _1 = COUNT(Tbl_Responses[Response])VAR _2 = CALCULATE(COUNT(Tbl_Responses[Response]), &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FILTER(ALLSELECTED(Tbl_Responses), Tbl_Responses[Date] = MIN(Tbl_Responses[Date])))RETURN_1/_2&nbsp;...which has worked well in a clustered column chart......however my preference would be to have it in a Matrix, however when using the same DAX, I get the following...Changing the % to % of overall total, row total and column total obviously throw it out even more, so I'd like to know if it's possible (and how) to amend that DAX so that I can replicate the correct % displayed in the Clustered Column chart?

lbendlin · Answer

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Forum Discussion

Calculating % from Unpivoted Data

1 Reply

Related content

Pivot / Unpivot?

Unpivot Column

Unpivot Question

Unpivot

Unpivot columns