Switch Case for Every Column Value

[Anonymous]

Hey Guys,
I need some urgent help here.So i have the data as in mentioned format below :

Questions	Category
Question 1	A
Question 2	B
Question 3	C
Question 4	A
Question 5	B
Question 6	C

So i have different questions which are categorized.I have already created measures for different questions and categories and i am using below code to show it in a table 

Switch_CXI_Questions = SWITCH(MAX(Table1[Category]),"Question1",[Average question1],
"Question2",[Average question2],.....,"Question6",[Average Question 6])

[Anonymous]

The answer is... It's wrong. Simply.

Best
D

[Pragati11]

Hi @Anonymous ,

Did you miss the question here? 😛

Thanks,

Pragati

[sturlaws]

Hi @Anonymous 

is there a question here?

Cheers,
Sturla