Need help with my measure

Hello abanar2 

Try this approch

Extract Selected Quarter Info

We'll extract selected year and quarter from the slicer selection.

VAR SelectedQuarterText = SELECTEDVALUE('99999_Calendar'[Year-Quarter])

VAR SelectedYear = VALUE(LEFT(SelectedQuarterText, 4))

VAR SelectedQtrNum = VALUE(RIGHT(SelectedQuarterText, 1))

 Generate Last 5 Quarters List

Use logic to generate year-quarter values of the last 5 quarters.

VAR Last5Quarters =

    ADDCOLUMNS(

        GENERATESERIES(0, 4, 1),

        "QtrOffset", [Value],

        "Year", SelectedYear - INT((SelectedQtrNum - [Value]) < 1),

        "Quarter", MOD(SelectedQtrNum - [Value] - 1 + 4, 4) + 1

    )

VAR Last5QuarterText =

    SELECTCOLUMNS(

        Last5Quarters,

        "Year-Quarter", FORMAT([Year], "0000") & "-Q" & [Quarter]

    )

Final Measure

_m_cnt_closed_last_5_quarter =

VAR SelectedQuarterText = SELECTEDVALUE('99999_Calendar'[Year-Quarter])

VAR SelectedYear = VALUE(LEFT(SelectedQuarterText, 4))

VAR SelectedQtrNum = VALUE(RIGHT(SelectedQuarterText, 1))

VAR Last5Quarters =

    ADDCOLUMNS(

        GENERATESERIES(0, 4, 1),

        "QtrOffset", [Value],

        "Year", SelectedYear - INT((SelectedQtrNum - [Value]) < 1),

        "Quarter", MOD(SelectedQtrNum - [Value] - 1 + 4, 4) + 1

    )

VAR Last5QuarterText =

    SELECTCOLUMNS(

        Last5Quarters,

        "Year-Quarter", FORMAT([Year], "0000") & "-Q" & [Quarter]

    )

RETURN

CALCULATE(

    [_m_cnt_closed_item],

    KEEPFILTERS(TREATAS(Last5QuarterText, '99999_Calendar'[Year-Quarter]))

Thanks

 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.