I am trying to work with some survey data where I would like to be able to select the answer to one question and have the other visuals filter to the answers for their question based on the customers selected in the first visual.
I should note that in the actual survey data, on some questions, a single user can submit multiple responses so I don't think turning the response table into a matrix is an option.
In the example below, if you select "red" under "What is your favorite color?" you see there are 4 customers that answered "red" (Jane, Ann, Mike, Erin). The problem is, I can't figure out how to write the customer count on the visuals so it inherits the customers from the first visual. They just blank out:
Current result to a selection
This would be the desired result (made by cutting and pasting parts of images)
I have tried variations of all and variables but can't get it to behave.
What is your favorite letter testing? =
VAR CustomersList = VALUES ( Responses[CustomerID] )
--ALL ( Responses ),
--ALL ( Responses[QuestionKey],Responses[CustomerID] ),
ALL ( Responses[QuestionKey]),
Responses[QuestionKey] = 3