Multiple choices answer count

Hi shugs,

If you data is in that format you present first of all you need to change you information format.

Go to the query editor and do the following steps:

1. Choose column Choice
2. Transform -> Split column -> By Delimeter
   1. Choose the comma as your delimeter
   2. Now you have a table with Project and one column per response
3. Choose all the columns besides the project
4. Transform -> Unpivot Columns
   1. Return a table with: Project, Attribute, Value
5. Delete column Attribute
6. Rename Value to your choice
7. Save and return to PBI desktop

Now just add you Value to the table visual and the Project (this should be count)

Regards,

MFelix