Create table from other table - calculations

[Jebilaya]

I have a table (VOC Results) that contains various survey questions and responses.  In order to display the data as I want in a clustered column chart I need to create a new table that takes each of the headers and gives me the total number of Excellent and Very Poor Responses.

So I created a new table with the question names and i've put in some fake numbers so you can see the results I need.

How would I write DAX to give me the total excellent and Very Poor responses for each question?

[NickolajJessen · Accepted solution]

Hi @Jebilaya 

I think you should look into unpivoting your data.
From there it's much easier to do a simple counter

[Jebilaya]

I agree in theory, but I can only do that for one of the question categories as if I do it for any others it errors as the field already exists