Moving Average Calculation Difference

Hi yogeshk77 ，

As checked the two pbix files you provided, and in the new file, you get the summary value for the field [Story_Points_10004] directly. In the old file you can also modify the measure [Last 6 Avg] as follows with the similar idea: first get the summary value of each directory, and then get the desired result based on the conditions.

Measure = 
VAR _SUMMARIZE =
    SUMMARIZE (
        ALLSELECTED ( WeightedVel ),
        WeightedVel[Learnosity_Team_10202],
        WeightedVel[Reporting Sprint ID],
        WeightedVel[Reporting Sprint Name],
        "SUMOFSP", CALCULATE ( SUM ( WeightedVel[Story_Points_10004] ) )
    )
VAR _ADDRANK =
    ADDCOLUMNS (
        _SUMMARIZE,
        "RANK",
            RANKX (
                FILTER (
                    _SUMMARIZE,
                    [SUMOFSP] > 0
                        && [Learnosity_Team_10202] = EARLIER ( [Learnosity_Team_10202] )
                ),
                [Reporting Sprint ID],
                ,
                DESC,
                DENSE
            )
    )
VAR _ADDLAST6AVG =
    ADDCOLUMNS (
        _ADDRANK,
        "LAST6AVG",
            IF (
                [RANK] <= 6,
                AVERAGEX (
                    FILTER (
                        _ADDRANK,
                        [Learnosity_Team_10202] = EARLIER ( [Learnosity_Team_10202] )
                            && [RANK] >= EARLIER ( [RANK] )
                            && [RANK]
                                <= EARLIER ( [RANK] ) + 5
                    ),
                    [SUMOFSP]
                )
            )
    )
RETURN
    SUMX (
        FILTER (
            _ADDLAST6AVG,
            [Learnosity_Team_10202] = MAX ( WeightedVel[Learnosity_Team_10202] )
                && [Reporting Sprint ID] = MAX ( WeightedVel[Reporting Sprint ID] )
        ),
        [LAST6AVG]
    )

Best Regards