Forum Discussion

giorgiokatr's avatar
giorgiokatr
Helper V
9 years ago
Solved

table with dynamic values (columns)

is it possible in a table to have dynamic values depending on a slicer?     Rows will have Branch and values will have different columns each time i select a value from a slicer (eg sales when i...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

giorgiokatr's avatar
giorgiokatr
Helper V
9 years ago

thanks Anonymous great and clever solution!

giorgiokatr's avatar
giorgiokatr
Helper V
9 years ago

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