DAX Help

[meena16_vibrant]

In a matrix, I need to show below measures for each column.

coln 1	measure 2
coln 2	Average(coln4)
coln 3	Max(Coln4)

I tried using below measure but I get error. Please help to get the write DAX.

Measure 1 =
SWITCH (
SELECTEDVALUE( Table[coln 1] ), Measure 2,
SELECTEDVALUE( Table[coln 2] ), AVERAGE ( coln4 ),
SELECTEDVALUE ( Table[coln 3] ), MAX ( coln4 )
)

[AllisonKennedy]

@meena16_vibrant 

What does your 'Table' look like?

You need to use true/false (yes/no) questions in your SWITCH, for example:

Measure 1 =
SWITCH (
SELECTEDVALUE( Table[coln] ) = "coln 1", [Measure 2],
SELECTEDVALUE( Table[coln] ) = "coln 2", AVERAGE ( coln4 ),
SELECTEDVALUE ( Table[coln] ) = "coln 4", MAX ( coln4 )
)

Can you provide more detail on what you're trying to acheive?

[meena16_vibrant]

@AllisonKennedy 

This how table looks. I have given dummy data 

[AllisonKennedy]

@meena16_vibrant  Thanks - can you make your dummy data a bit more meaningful? I can't see why you have two rows with almost the same data and why that same data needs to be the trigger for a different measure. Can you simply do three measures:

AAA = [measure1]

BBBB = AVERAGE(table[coln4])

CCC = MAX(table[coln4])

And add those three measures to a matrix or table visual?