Calculated groups using Tabular Editor

[pbi_wannabe_exp]

The strange thing that I cant make one measure working. The first part of the calculation (Actual Sprint) shows correct data, but the second part which should be the previous sprint value, returns to the actual result. The result calculation should follow the red framed calculation (based on a sprint selector in PBI). I tried to modify -1 Sprint Wk CC to -5 or -3 etc., it doesn't show any difference. Any hints? Many thanks in advance!

[Anonymous · Accepted solution]

HI @pbi_wannabe_exp,

I think this scenario may be related to the 'all' function, it will ignore all filters on the table so it may conflict with getting the current field value. (max function are calculated on the fixed all table records and get static result)

ALL function (DAX) - DAX | Microsoft Docs

Have you tried to create a variable and move this type of operation out of the current calculation row context?

formual =
VAR currValue =
    MAX ( Calendar[Sprint Year CC] )
RETURN
    CALCULATE (
        SELECTEDMEASURE (),
        FILTER ( ALL ( Calendar ), [Sprint Year CC] <= currValue )
    )

Regards,

Xiaoxin Sheng