Forum Discussion
Use Measure as a Column
Hello, I have a requirement where in I have created three what if parameters and created measures for it as follows. Measure 1: ABC Cogs = Var A = SELECTEDVALUE('A Anlysis'[A Anlysis]) Var...
Hi,
Share some data and show the expected result.
Anonymous You can use this pattern that Avi Singh came up with.
https://www.youtube.com/watch?v=WV5KxZRIzUE
It uses a disconnected table with the columns that you want to appear on the rows/columns of a matrix. Then a single measure uses multiple, nested SWITCH( TRUE() ) patterns to determine which measure to return in each "cell" of the matrix.
This sort of measure will have a performance hit, but it's the only easy(ish) way to solve problems like this.
Hope this helps,
~ Chris Haas