Forum Discussion
Comparing averages to a baseline date
Community ChampionAnonymous
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
it seems that baselineAverage is the one that's off. using the bellow measure I get the following result.
- az38
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?
Yes that is my fault, I should have shared the model.
For this calculation I only use Runtime Info table. The model is something like this:
I have multiple queries in the Query column where each query has 20 event IDs. Each event ID has one response time (event time) and the event count (which is the date returned).
In one day I run each query more than once so I want for each query to get an average response time (event time) from all of its event IDs.
I hope it makes more sense now.
- az38
Anonymous
If i understand you correct you need an average Event Time by Query?
if so, try like
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]), ALLEXCEPT('Runtime Info', 'Runtime Info'[Query])) RETURN baselineAverage - currentAverage