Forum Discussion

vr_2020

Frequent Visitor

5 years ago

Solved

Hierarchy Slicer

I have a scenario where the data in a Table is available in column wise as follows: Continents Countries Cities ASIA INDIA CHENNAI ASIA INDIA MUMBAI ASIA I...

Need Help

v-janeyg-msft

5 years ago

Hi, vr_2020

Try like this:

Measure = 
SWITCH (
    TRUE (),
    ISFILTERED ( 'Table'[Column3] ), MAX ( 'Table'[Column3] ),
    ISFILTERED ( 'Table'[Column2] ),
    MAX ( 'Table'[Column2] ), 
    ISFILTERED ( 'Table'[Column1] ), MAX ( 'Table'[Column1] ),
    " "
)

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-janeyg-msft

Community Support

5 years ago

Hi, vr_2020

Try like this:

Measure = 
SWITCH (
    TRUE (),
    ISFILTERED ( 'Table'[Column3] ), MAX ( 'Table'[Column3] ),
    ISFILTERED ( 'Table'[Column2] ),
    MAX ( 'Table'[Column2] ), 
    ISFILTERED ( 'Table'[Column1] ), MAX ( 'Table'[Column1] ),
    " "
)

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.