Measure Slicer with repeated measures on various data points

[01UmaManoharan]

Hi All,

I have a scenario where I have measures on below

cancelled in 15 days, cancelled in 30 days, cancelled in 45 days, cancelled in 60 days( 4 measures)

paid in 15 days, paid in  30 days , paid in 45 days, paid in 60 days(4 measures)

unpaid in 15, 30, 45, 60 (4 measures)

all the days performace are from issued date(eg: paid in 15 days from the issued date. cancelled date is also used for cancellations)

I need to create a measure slicer where i need this measure names as filter. when i pick 15 days in slicer it should slice my table for all paid, cancelled, unpaid with 15 days performace.

Can you guys help me on this please?

Note: I just simplified the scenario, would it be possible to create a measure slicer with filed parameters, when i have mulitple measures for one category.

i did not go for calculation groups as i have no idea how to pull the calculation groups in measure slicer. in table the output should be like measures in rows and measures in values. cancelled, paid and unpaid should be rows(these are DAX calculations not an actual value in column)

Thanks in advance

[Sahir_Maharaj · Accepted solution]

Hello @01UmaManoharan,

Can you please try the following:

1. Create a Disconnected Table for the Slicer

TimeFrameSlicer = DATATABLE(
    "TimeFrame", STRING,
    "Days", INTEGER,
    {
        {"15 days", 15},
        {"30 days", 30},
        {"45 days", 45},
        {"60 days", 60}
    }
)

2. Create Dynamic Measures

DynamicMeasure = 
VAR SelectedTimeFrame = SELECTEDVALUE(TimeFrameSlicer[Days], 15)
RETURN
SWITCH(
    SelectedTimeFrame,
    15, [YourMeasureFor15Days],
    30, [YourMeasureFor30Days],
    45, [YourMeasureFor45Days],
    60, [YourMeasureFor60Days],
    BLANK()
)

Hope this helps!