Sorting based on a slicer values selection

Hi,

Here is my test sample:

Please take following steps:

1)Create a slicer table by Enter Data:

2)Try this measure:

Measure = 
SWITCH (
    SELECTEDVALUE ( SlicerTable[Slicer] ),
    "Sort by Date", RANKX (
        ALLSELECTED ( 'Table' ),
        CALCULATE ( MAX ( 'Table'[Date] ) ),
        ,
        ASC,
        DENSE
    ),
    "Sort by Target_Sales", RANKX (
        ALLSELECTED ( 'Table' ),
        CALCULATE ( SUM ( 'Table'[Target_Sales] ) ),
        ,
        ASC,
        DENSE
    ),
    RANKX (
        ALLSELECTED ( 'Table' ),
        CALCULATE ( SUM ( 'Table'[Actual-Sales] ) ),
        ,
        ASC,
        DENSE
    )
)

3)Add this measure to the table visual, and set this visual sort by above measure:

4)When selecting one value in slicer, the result shows:

See my attached pbix file.

Best Regards,

Giotto