SURVEY FORM

[Syndicate_Admin]

Hello

I hope you are well

I need help urgently, I relicted a survey of 20 questions virtually, to process them in Power BI I assigned a code to each form, I used a code to identify each question and I gave it an answer value as I show below.

Currently, I have to categorize the respondents according to 5 categories (Excellent, good, fair, weak, insufficient), for which I have made a first distribution, for which, I created a new table eliminating the duplicate IDs, which gave me a first result in which the number of answers and their respective category appear, as shown in the image (however, Although the distribution subtable is connected to the parent table, it does not allow me to use the dimension filter.

Now I need to find the distribution of respondents according to the Dimension category. Each dimension consists of 4 questions (which are categorized by a code from 1 to 20). Every time I try to put the number of responses by category, I get numbers that do not match my number of respondents, as shown below:

Also, my distributions don't match.

I will be super attentive if anyone can help me

[Syndicate_Admin]

The idea is to be able to make the following table, with the number of people who are in the categories: