cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Gladiator2019 Frequent Visitor
Frequent Visitor

Mulitple Responses Survey Question

Hi everyone,

I have some survey results where each user had the opportunity to select multiple answers to analyze and I am a bit stuck...

Here is a snapshot of the data:snap1.PNG

 

As you guys can see from the above, a player can play multiple games on multiple devices.

 

So what I wanted to display on my dashboard is a table or bar chart of the consoles along with a slicer for the games played.

 

To achieve that, I did the following:

 

Step 1: Unpivot the Games. Here is the result:

snap2.PNG

 

Step 2: Unpivot the above but for the consoles; here is the result:

snap3.PNG

Step 3: On the canvas, I did the following:

snap4.PNG

And this works well; the numbers tally up properly!

 

However, if I were to remove all the filters (No selection), the numbers do not make sense anymore. 

Here how it looks like:

snap5.PNG

I would like the table to just show the number of times the game was played irrespective of the console when there is no selection.

That is: 

Fortnite: 18

FIFA 19: 11

Need For Speed:10

Call of Duty: 6

NBA 2K19: 3

 

Can anyone please help me with this? Please me know if there is a better way of doing it.

 

Thank you very much

 

1 ACCEPTED SOLUTION

Accepted Solutions
sturlaws Established Member
Established Member

Re: Mulitple Responses Survey Question

Great. So what you actually are trying to do, is to show the number of respondents pr game and device. There is nothing wrong with your code, but your dataset has some issues. There is no way of identifying a respondent. You can change this by adding a column in your excel file with a uniqie number pr row, or you can add an index column in power query.

I would have shared a file with you showing how it could be done with power query, but it seems like you are using an older version of power bi desktop, so you would not be able to open any file I send you.

cheers,
S

4 REPLIES 4
sturlaws Established Member
Established Member

Re: Mulitple Responses Survey Question

Hi,
I think what you have done should work, and I am not able to recreate the behaviour you experience. Perhaps you could upload a sample of your file to dropbox/onedrive/other and share the link here?

 

cheers,

S

Gladiator2019 Frequent Visitor
Frequent Visitor

Re: Mulitple Responses Survey Question

sturlaws Established Member
Established Member

Re: Mulitple Responses Survey Question

Great. So what you actually are trying to do, is to show the number of respondents pr game and device. There is nothing wrong with your code, but your dataset has some issues. There is no way of identifying a respondent. You can change this by adding a column in your excel file with a uniqie number pr row, or you can add an index column in power query.

I would have shared a file with you showing how it could be done with power query, but it seems like you are using an older version of power bi desktop, so you would not be able to open any file I send you.

cheers,
S

Gladiator2019 Frequent Visitor
Frequent Visitor

Re: Mulitple Responses Survey Question

Ohh ok!

 

So I added the index column to the table.

 

then my value count is the "Distinct Count" of the index... So we can identify individual respondents.

 

That seems to work!

 

Thank you

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 410 members 4,241 guests
Please welcome our newest community members: