Add Average Line in Gauss Curve

[Anonymous]

Good Afternoon All, 

I am needing some help as I have exhausted everyting I can think of in doing this. I have a Gauss Curve, or "bell curve" I created for information related to how many days difference vendors are from getting their purchase orders to us on time (called DayDiff). With this data I was able to review a video that showed me how to create a bell curve graph. What I would like to do now is create measure/calculated column to be able to display the mean and std dev +- 1 and +- 3 within the curve and the data label associated. I undertand this may sound like a lot, in fact I have tried all kinds of ways to manipulate it but I can't seem to get it. Below is all the information. 

 The Measures created for the red (mean) and the blue (std dev):

(µ) DayDiff = AVERAGE(OnTimeDelivery[DayDiff])

(σ) DayDiff = STDEV.S(OnTimeDelivery[DayDiff])

Measures for +-1 and +-3:

x+1σ = [(µ) DayDiff] + 1*[(σ) DayDiff]

x-1σ = [(µ) DayDiff] - 1*[(σ) DayDiff]

x+3σ = [(µ) DayDiff] + 3*[(σ) DayDiff]

x-3σ = [(µ) DayDiff] - 3*[(σ) DayDiff]

*Hopefully this information helps. Any help would be appreciated, thank you!

[Greg_Deckler]

If that is a line chart visualization, there is a built in Average line in the analytics pane in the Visuals area (magnifying glass icon). Also, for you measures, you may be able to change them to the following:

(µ) DayDiff = AVERAGE(ALL(OnTimeDelivery[DayDiff]))

(σ) DayDiff = STDEV.S(ALL(OnTimeDelivery[DayDiff]))

Then you should be able to add them to the Values area of your visual.

[Anonymous]

So the visual is a line and stacked column chart and when I click the Magnify glass it states that analysis can't be done. I also tried the ALL function in the rewritten measures but it kept giving me an error and would not function. If it helps here is kind of more what I am looking for: 

[Greg_Deckler]

Sorry, probably:

(µ) DayDiff = AVERAGEX(ALL(OnTimeDelivery),[DayDiff])

(σ) DayDiff = STDEVX.S(ALL(OnTimeDelivery),[DayDiff])