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...
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

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