Forum Discussion
Create table from other table - calculations
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?
Hi Jebilaya
I think you should look into unpivoting your data.
From there it's much easier to do a simple counter
2 Replies
Hi Jebilaya
I think you should look into unpivoting your data.
From there it's much easier to do a simple counterI 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
