Forum Discussion

rgadbois's avatar
rgadbois
Frequent Visitor
3 years ago

Create Baseline and Percentage Deviation from Baseline

Hi,   I have a large report with all Sports Science data for athletes. One table I am using has all relevant data for a particular piece of technology, in which the columns are sorted Date, Athlete...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

rgadbois Maybe:

Baseline Measure = AVERAGEX(SUMMARIZE(FILTER(ALL('Table'),[Date]=DATE(2022,9,1)),[Athlete],"__Metric",SUM('Table'[Metric])),[__Metric])



Percent Diff Measure = 
  VAR __Current = AVERAGEX(SUMMARIZE('Table',[Athlete],"__Metric",SUM('Table'[Metric])),[__Metric])
RETURN
  DIVIDE(__Current - [Baseline Measure],[Baseline Measure],0)
  • rgadbois's avatar
    rgadbois
    Frequent Visitor
    3 years ago

    I got this to work! I tested it out with a card with a page filter based on each individual player, yet the baseline is set for everyone, and not individually. Is there a way to fix that?

  • rgadbois's avatar
    rgadbois
    Frequent Visitor
    3 years ago

    Thank your for your help! I seem to be close, but I keep getting the following error:

    my table name is "CMJ" and the metric is "RSI-modified [m/s]"

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      3 years ago

      rgadbois Guessing you need one extra ] on your SUM('CMJ'[RSI - modified[m/s]]]])),...