Consolidating count from columns that are broken apart by a multi-select dropdown

[Hangman2TW]

Hello all.

I'm currently trying to report on the count of "Affected Environements" that have been selected in my data.

The issue is that the input for this data is from a multi-select dropdown. When this data is imported into Power BI, it creates a new column for each additional result that has been selected. I'm happy to keep these columns seperated, as all I want to do is have a count of how often each environement has been selected (based on the date found earlier in the row), but when I attempt to add any of the additional "Affected Environment" columns into a chart, it will just duplciate the results of the original "Affected Environment" field.

This image above  shows me entering both the original affected environemnt column along with one of the extra columns that was created. There's a sample table below which shows how the data is stored on the back end (see two rows that have multipe selections). As you can see, the chart has just doubled the result. Am i configuring the chart wrong, or do I need to do something to the data to make this work?

The chart should ideally look like this, but with higher results:

Here's an image of what the query data looks like:

Thank you for your time reading this,

[lbendlin]

Different from what you may be used to from Excel, in Power BI you want to have narrow, long tables. Most likely you will get better results when you unpivot your source data.