Calculating % from Unpivoted Data

Tob_P — Fri, 27 Oct 2023 09:17:18 GMT

Hi all,

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...

Yes/No % =

VAR _1 = COUNT(Tbl_Responses[Response])

VAR _2 = CALCULATE(COUNT(Tbl_Responses[Response]),

FILTER(ALLSELECTED(Tbl_Responses), Tbl_Responses[Date] = MIN(Tbl_Responses[Date])))

RETURN

_1/_2

...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?

Re: Calculating % from Unpivoted Data

lbendlin — Sat, 28 Oct 2023 18:11:53 GMT

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

topic Re: Calculating % from Unpivoted Data in DAX Commands and Tips

Calculating % from Unpivoted Data

Re: Calculating % from Unpivoted Data