Appended Table Summarised Results - Count a distinct value by ROW

Hi  Datastud3nt , 

then here's a different solution for your problem. 

Open the Power Query Editor by clicking the Transform Data button in the upper tab menu:

If you then select your table you should see something similar like this:

Duplicate the existing answer table by right clicking on the table in the left Queries pane:

Then select the newly created table. I named it ANSWERS_PIVOT. Select all colums with answers except your Row column which is here represented by the Answer column. 

Then do a right click and select Unpivot Columns.

The result should look somethink like this

Click Save and switch back to your report view. 
There you create a measure for each answer like this: 

COUNT_STRONGLY_AGREE = CALCULATE(COUNTX('ANSWERS_PIVOT', 'ANSWERS_PIVOT'[Value]), 'ANSWERS_PIVOT'[Value] = "Strongly Agree")

Add the measures as colums to your ANSWERS table and you will get the following result: