Forum Discussion
DAX Help
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...
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 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?
