Combine the values from different columns into one slicer - then filter the table based on selection

[Anonymous]

Hello Everyone

I would like to combine  Sign1 and Sign2 in one slicer, then based on selection from the slicer I would like to find the max date.

Sample table-

Result Expected-

Thanks in advance

[AlexisOlson · Accepted solution]

You'll need to create a new table for the slicer. You can do this in the query editor or in DAX like this:

SignSlicer = DATATABLE ( "Sign", STRING, { { "P" }, { "Q" } } )

Once you have that, you can define the Max Date measure.

Max Date =
SWITCH (
    SELECTEDVALUE ( SignSlicer[Sign] ),
    "P", CALCULATE ( MAX ( Table1[Dates] ), Table1[Sign1] = "P" ),
    "Q", CALCULATE ( MAX ( Table1[Dates] ), Table1[Sign2] = "Q" ),
    MAX ( Table1[Dates] )
)