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 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 )
)
3 Replies
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?
