undefined

[Anonymous]

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

[v-easonf-msft · Accepted solution]

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

[Anonymous]

Thank you soo much for your valuable help😊