cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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 New Contributor
New Contributor

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

View solution in original post

4 REPLIES 4
sturlaws New Contributor
New Contributor

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 New Contributor
New Contributor

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

View solution in original post

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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 277 members 2,675 guests
Please welcome our newest community members: