Count of distinct values and display % of overall?

[monicarysavy]

I have a column of Likert responses (1-5) and need to count the number of 1s, 2s, etc... and display the % of the overall reponses for each value in a table. Is this possible to achieve?

My table would have something like this: Strongly Agree =1 and Disagree=2

       Strongly Agree     Disagree       

UG         1.88%                6.45%

GR         1.18%                 3.53% 

[Eric_Zhang]

---

@monicarysavy wrote:

I have a column of Likert responses (1-5) and need to count the number of 1s, 2s, etc... and display the % of the overall reponses for each value in a table. Is this possible to achieve?

My table would have something like this: Strongly Agree =1 and Disagree=2

       Strongly Agree     Disagree       

UG         1.88%                6.45%

GR         1.18%                 3.53% 

---

@monicarysavy

Not a table, but use a matrix as @MFelix suggests.

An addtion, create a calculate column and use it as  the column in the matrix.

level =
SWITCH (
    TRUE (),
    'Table'[response] = 1, "Strongly Agree",
    'Table'[response] = 2, "Agree",
    'Table'[response] = 3, "neutral",
    'Table'[response] = 4, "Disagree",
    "Strongly Disagree"
)

[MFelix]

Hi @monicarysavy,

If you select the matrix visual and then add the [ID (UG/GR)] to the Rows and the [Likert response] to the Columns then for values choose the [Likert response] this will give you the count of each likert in the ID then just choose the show value as Percent of Grand Total and should give what you need.

You can also choose to have the percentage for column or row total,

Regards,

MFelix