Help with measure for rolling NPS

Hi zh1988 

The Basic measures you need:

Promoters =
CALCULATE(
    COUNTROWS('fact_table'),
    'fact_table'[nps score] >= 9
)

Detractors =
CALCULATE(
    COUNTROWS('fact_table'),
    'fact_table'[nps score] <= 6
)

TotalResponses =
COUNTROWS('fact_table')

NPS =
DIVIDE(
    [Promoters] - [Detractors],
    [TotalResponses],
    0
) * 100

 
The Rolling Sums:

RollingPromoters =
VAR CurrentMonthOrder = MAX('DateTable'[MonthNumber])
VAR SelectedMonths =
    CALCULATETABLE(
        VALUES('DateTable'[MonthNumber]),
        ALLSELECTED('DateTable')
    )
VAR MinSelectedMonth = MINX(SelectedMonths, [MonthNumber])
RETURN
CALCULATE(
    [Promoters],
    FILTER(
        ALL('DateTable'),
        'DateTable'[MonthNumber] >= MinSelectedMonth &&
        'DateTable'[MonthNumber] <= CurrentMonthOrder
    )
)

RollingDetractors =
VAR CurrentMonthOrder = MAX('DateTable'[MonthNumber])
VAR SelectedMonths =
    CALCULATETABLE(
        VALUES('DateTable'[MonthNumber]),
        ALLSELECTED('DateTable')
    )
VAR MinSelectedMonth = MINX(SelectedMonths, [MonthNumber])
RETURN
CALCULATE(
    [Detractors],
    FILTER(
        ALL('DateTable'),
        'DateTable'[MonthNumber] >= MinSelectedMonth &&
        'DateTable'[MonthNumber] <= CurrentMonthOrder
    )
)

RollingTotalResponses =
VAR CurrentMonthOrder = MAX('DateTable'[MonthNumber])
VAR SelectedMonths =
    CALCULATETABLE(
        VALUES('DateTable'[MonthNumber]),
        ALLSELECTED('DateTable')
    )
VAR MinSelectedMonth = MINX(SelectedMonths, [MonthNumber])
RETURN
CALCULATE(
    [TotalResponses],
    FILTER(
        ALL('DateTable'),
        'DateTable'[MonthNumber] >= MinSelectedMonth &&
        'DateTable'[MonthNumber] <= CurrentMonthOrder
    )
)

 
Rolling perc & NPS:

RollingPromotersPct =
DIVIDE(
    [RollingPromoters],
    [RollingTotalResponses],
    0
)

RollingDetractorsPct =
DIVIDE(
    [RollingDetractors],
    [RollingTotalResponses],
    0
)

RollingNPS =
DIVIDE(
    [RollingPromoters] - [RollingDetractors],
    [RollingTotalResponses],
    0
) * 100

Please do mention the kind of issue faced or what discrepancy occurs if this doesn't help

Hi there, thank you very much!! When first applying the measures it did not take the year slicer into account (I also did not mention that explicitly) so the totals were based on the complete data set, but by adding a month key into allmeasures it now shows correct data.