Forum Discussion
switch value depends on rows in matrix
Hi, Here the sample data, I created a matrix that drag the column1, dim1, dim2 to rows, and measure to values, I want the row subtotal not display total of each category, rather show the column1 lev...
Anonymous , You can use isinscope in a new measure
Switch( true(),
isinscope(Table[dim2]), Sum(Table[Value2]) ,
isinscope(Table[dim1]), Max(Table[Value1]) ,
isinscope(Table[Col1]), Max(Table[Value1]) )
amitchandak
Super User
Super UserAnonymous , You can use isinscope in a new measure
Switch( true(),
isinscope(Table[dim2]), Sum(Table[Value2]) ,
isinscope(Table[dim1]), Max(Table[Value1]) ,
isinscope(Table[Col1]), Max(Table[Value1]) )