Forum Discussion

SteveIOW's avatar
SteveIOW
Icon for Helper II rankHelper II
4 years ago
Solved

create a constant value

Good afternoon,   I am trying to use linear rgeression to caluclate how long it will take to reach a target. In the chart below you cna see the target as the horizontal red line - generated from  ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    SteveIOW , Try a measure like

     

    calculate(AVERAGEX(KEEPFILTERS(VALUES('PreC'[Date])), CALCULATE(SUM('PreC'[Value]))) * 1.2, allselected())

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

SteveIOW , Try a measure like

 

calculate(AVERAGEX(KEEPFILTERS(VALUES('PreC'[Date])), CALCULATE(SUM('PreC'[Value]))) * 1.2, allselected())