Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 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
    5 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))
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

Try this

Baseline = CALCULATE(AVERAGE(Indicators_Value[Value_%]),datesbetween(calendar[date],minx(all(calendar),calendar[date]),minx(all(calendar),calendar[date])))
Hope this helps.
 
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

 

Not yet. 

Baseline = CALCULATE(AVERAGE(Indicators_Value[Value_%]),datesbetween(calendar(Indicators_Value[Date],minx(all(calendar),calendar(Indicators_Value[Date]),minx(all(calendar),calendar(Indicators_Value[Date])))
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    You must have a Calendar Table.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Arthur,

       

      I tried with calendar table but it is changing by date slicer.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        5 years ago

        Hi,

        Share the download link of the PBI file and show the expected result very clearly.