Forum Discussion
undefined
HI,
I"m unable to understand why this measure is not working...
SCENARIO :
I want to show the data of a table that contains 3 accounts 1) Grut 2)lik 3) jag
i have above 3 accounts and in the slicer i need to show Grut & jag ,
requirement 1- when i clicked on Grut it should show Grut and lik data
requirement 2- when i clicked on jag it should show jag and lik data..
I TRIED CREATING THIS MEASURE
selection = var sm=SELECTEDVALUE(table(col(grut,lik,jag))
Return if(sm="grut",filter(table,table(col)<>jag),if(sm="jag",filter(table,table(col)<>grut,"null")
and it showing as "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."
Please help me to resolve this and show the data
Hi, Anonymous
Try the following steps:
1. enter a new table 'Slicer Table'
2. put a filter measure to your table visual filter pane
filter = VAR a = SWITCH ( SELECTEDVALUE ( 'Slicer Table'[Value] ), "Grut", IF ( MAX ( 'Table'[Column] ) IN { "Grut", "lik" }, 1 ), "jag", IF ( MAX ( 'Table'[Column] ) IN { "jag", "lik" }, 1 ), 0 ) RETURN IF ( ISFILTERED ( 'Slicer Table'[Value] ), a, 1 )Best Regards,
Community Support Team _ Eason
2 Replies
Hi, Anonymous
Try the following steps:
1. enter a new table 'Slicer Table'
2. put a filter measure to your table visual filter pane
filter = VAR a = SWITCH ( SELECTEDVALUE ( 'Slicer Table'[Value] ), "Grut", IF ( MAX ( 'Table'[Column] ) IN { "Grut", "lik" }, 1 ), "jag", IF ( MAX ( 'Table'[Column] ) IN { "jag", "lik" }, 1 ), 0 ) RETURN IF ( ISFILTERED ( 'Slicer Table'[Value] ), a, 1 )Best Regards,
Community Support Team _ Eason