How to show slicers

Hi GAURAV7781 

I build a sample table and tried your measure, I found when you select WS/SW your measure _Selected will output "SW".

So in your return when output ="WS", the result is blank.

I update your measure:

Area. = 
VAR _Selected =
    ALLSELECTED ( 'Exported Data-RGA'[Area] )
VAR _CON =
    CONCATENATEX ( _Selected, 'Exported Data-RGA'[Area] )
VAR _Output =
    IF ( _CON = "SW", "WS", _CON )
RETURN
    IF (
        ISFILTERED ( 'Exported Data-RGA'[Area] ),
        SWITCH (
            _Output,
            "W", "Warehouse",
            "S", "Sales",
            "MNRSTW", "Total Returns",
            "WS", "IMS Caused"
        ),
        BLANK ()
    )

Result is as below.

Select "WS"

You can download the pbix file from this link: How to show slicers

Best Regards,

Rico Zhou

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