Calculated groups using Tabular Editor

pbi_wannabe_exp — Fri, 06 May 2022 13:19:01 GMT

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!

Re: Calculated groups using Tabular Editor

Anonymous — Mon, 09 May 2022 08:33:25 GMT

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

topic Re: Calculated groups using Tabular Editor in Developer

Calculated groups using Tabular Editor

Re: Calculated groups using Tabular Editor