Using donut chart/ pie chart as filter for a measure

Hi!

I'm encountering issue on using donut/pie chart as a filter for a measure.

So, I have data on (let's say) thousands of people who likes milk chocolate and/dark chocolate, and their score towards milk/dark chocolate (from a scale 0-10). A person can either likes/dislikes milk/dark chocolate.

The data looks something like this:

Goal: I want to know how NPS milk chocolate differs for milk chocolate.

So, this is what I did:

• I created an NPS measure from the 0-10 score data displayed as "NPS milk chocolate"
• I convert "yes" to "1" and "no" to (blank)
• I created donut/pie chart to diplay how many person likes/dislikes milk/dark chocolate as follows:

• When I use filter and choose "1" which means yes to the question "likes milk chocolate?", the Score milk chocolate becomes 24.81.

• But, when I click on the donut chart to select "Likes milk chocolate", the Score doesn't reflect the "Likes milk chocolate" I selected in the donut chart. --> I would expect to have 24.81 in the Score instead of 4.96. --> So, shouldn't this work in PowerBI? What could I do to make this work?

I tried to look for a solution in the forum, but the only thing I could find is to transform the table to have likes/dislikes milk/dark chocolate into one column (@https://community.powerbi.com/t5/Desktop/Donut-Chart-Using-Multiple-Columns/td-p/735950).

I need an easier solution if possible since transforming data may not work for me on a much complex data (e.g: what if I have 100 variant of chocolate, and one people can answer the question multiple times).