Forum Discussion

pbi_wannabe_exp's avatar
pbi_wannabe_exp
Regular Visitor
4 years ago
Solved

Calculated groups using Tabular Editor

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!

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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