Forum Discussion

spena's avatar
spena
Frequent Visitor
6 years ago
Solved

point difference between individual points versus average trend line value

Hi, I need help with the DAX for what I am trying to do! I am showing annualized churn over time, by week. There is a date slider in my dashboard to select which weeks to view. Based on the weeks sel...
  • spena's avatar
    spena
    6 years ago

    I was able to solve this by creating the following measures:

    ChurnCalc average =
    AVERAGEX(
        ALLSELECTED('ChurnDigital'[WeekId]),
        CALCULATE([Churn])
    )
     
    Churn var to avg = ChurnDigital[Churn] - ChurnDigital[ChurnCalc average] 
spena's avatar
spena
Frequent Visitor
6 years ago

I was able to solve this by creating the following measures:

ChurnCalc average =
AVERAGEX(
    ALLSELECTED('ChurnDigital'[WeekId]),
    CALCULATE([Churn])
)
 
Churn var to avg = ChurnDigital[Churn] - ChurnDigital[ChurnCalc average]