Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Comparing averages to a baseline date

Hello everyone! I want to take some averages that come from a baseline date, then take averages from all other dates and subtract the second one from the first. I have created a formula that is sh...
Need Help
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

what the statement do you use for [Average Event Time]  measure?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

az38  I use this one

 

Average Event Time = AVERAGE('Runtime Info'[Event Time])
  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous 

    ypur statement looks good enough

    didn't your try to debug? whats component is wrong? baselineAverage  or currentAverage?

    also, try this

    AET Difference with Baseline =
VAR baselineAverage = CALCULATE(AVERAGEX(FILTER(ALL('Runtime Info'), [Date] = DATE(2020, 04, 03)), [Event Time])
VAR currentAverage = CALCULATE(AVERAGE([Event Time]))

RETURN
baselineAverage - currentAverage

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      az38 

      it seems that baselineAverage is the one that's off. using the bellow measure I get the following result.

       

      AET Difference with Baseline =
      VAR baselineAverage = CALCULATE(AVERAGEX(FILTER(ALL('Runtime Info'), [Date] = DATE(2020, 04, 03)), [Event Time]))
      VAR currentAverage = CALCULATE(AVERAGE('Runtime Info'[Event Time]))

      RETURN
      baselineAverage
       
      • az38's avatar
        az38
        Icon for Community Champion rankCommunity Champion
        6 years ago

        Anonymous 

        no, baseline is good. it's the same in each rows as expected.

        for me this statement also work ok.

        please, show your data model more detailed. what columns do you use?