Forum Discussion
table with dynamic values (columns)
Hi giorgiokatr,
Sorry, It seems like I have forgot to paste the measures.
field1 =SWITCH([Selected],"Sales",Max(Table[Col1]),"Other",Max(Table[Col3])) field2 =SWITCH([Selected],"Sales",Max(Table[Col2]),"Other",Max(Table[Col4]))
Regards,
Xiaoxin Sheng
thanks Anonymous! what is the dax formula for field1 and field2?
Hi giorgiokatr,
Sorry, It seems like I have forgot to paste the measures.
field1 =SWITCH([Selected],"Sales",Max(Table[Col1]),"Other",Max(Table[Col3])) field2 =SWITCH([Selected],"Sales",Max(Table[Col2]),"Other",Max(Table[Col4]))
Regards,
Xiaoxin Sheng
Is it possible to do this when your measures use different formatting?
I have three measures that my users need to be able to swap out in the same field. This worked for the first two, which are the same format (whole number), but the third value is a percentage. Using this process I've only been able to keep all in the same format (whole number or percent for all).
thanks Anonymous great and clever solution!
and my only remaing problem Anonymous is how to name dynamic the field1 and field2.....
because noone will know that field1 has the values of column1
hi Anonymous
Could be please send the pbix file with multiple rows in the input table.
I am not able to see the exact output, I see the max value of the list of values in the columns as the DAX epression says(Max in it).
Thanks in advance.
Regards,Pramod Kumar
Hi v-shex-msft,
it's a great solution, i was strugling to get the column values based on the slicer selection from another table.
thanks for the solution.
Regards,
Swamy
