Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

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 a...

v-easonf-msft

3 years ago

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

undefined.pbix27 KB

v-easonf-msft

Community Support

3 years ago

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

undefined.pbix27 KB

Anonymous

Not applicable

3 years ago

Thank you soo much for your valuable help😊