Forum Discussion

01UmaManoharan's avatar
01UmaManoharan
Frequent Visitor
2 years ago
Solved

Measure Slicer with repeated measures on various data points

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

 

  • 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!

1 Reply

  • 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!