Formula for Column Summerization

[RobKay12]

Hello,

I have the below table example where each question is a column and the answers are the corosponding rows under. I ultimatley need to show my top 5 questions and how many times each were answered with a "Y" in a chart. I am looking for assistance with the formula to use to show this.

Any help is greatly appreciated.

Thanks

[wdx223_Daniel]

it's better to unpivot your table in M code to a table with two columns, Question and Answer

=Table.UnpivotOtherColumn(YourTable,"Question","Answer")

and upload it into your model

put the Question column in the row area

and put the below measure in the value area

CountY=CALCULATE(COUNTROWS(YourTable),YourTable[Answer]="Y")

[HotChilli]

Can you define this please? ->"show my top 5 questions"

--

Post the data as text (not a picture) and I'll have a go

[RobKay12]

I would like to show which of the top 9 questions have more "Y" in responses. For example:

Question 8 would be top question with all "y"s

Question 3 would be next with 4 "Y"s,

and so on.