Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Reference measure

Dear all, I would like to use a measure to calculate baseline values. In this case, the baseline is the data of the first date on each indicator (and each time, so it is corrected), blue background...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    My solution:

    Baseline ?
    VAR MIN_MONTH to MONTH(CALCULATE(MIN(Indicators_Value[Date].[ Closes]),FILTER(ALL(Indicators_Value),Indicators_Value[Indicator Id] - SELECTEDVALUE(Indicators_Value)))
    Return
    CALCULATE(
    AVERAGE(
    Indicators_Value[Value_%]),
    FILTER(
    ALL(Indicators_Value),
    Indicators_Value[ID del indicador] - SELECTEDVALUE(Indicators_Value[Indicator Id]) && Indicators_Value[Fecha]. [MesNo]-MIN_MONTH))
Anonymous's avatar
Anonymous
Not applicable
6 years ago

My solution:

Baseline ?
VAR MIN_MONTH to MONTH(CALCULATE(MIN(Indicators_Value[Date].[ Closes]),FILTER(ALL(Indicators_Value),Indicators_Value[Indicator Id] - SELECTEDVALUE(Indicators_Value)))
Return
CALCULATE(
AVERAGE(
Indicators_Value[Value_%]),
FILTER(
ALL(Indicators_Value),
Indicators_Value[ID del indicador] - SELECTEDVALUE(Indicators_Value[Indicator Id]) && Indicators_Value[Fecha]. [MesNo]-MIN_MONTH))