DAX fomula for Average Line using a Measure, SPC HELP!

[Beroccakid]

Need help! I am trying to create an SPC graph but I need to use a quick measure as my average line in order to have a lower and upper control limit (Mean +- 2 SD). I am using a measure which changes monthly but I can't seem to figure out the DAX formula to return the dotted blue line you see below. Any help is much appreciated!

[v-frfei-msft · Accepted solution]

Hi @Beroccakid ,

We can add the dotted blue line like this, and we canot add measure to the line.

[Anonymous]

hI @Beroccakid ,

Have you tried to use the average line under "Analytics" option (the magnificent lense icon)? If it fits your requeriment, it is easier.

[Beroccakid]

Hi @Anonymous 

The dotted line is from the analytics option but I would like the quick measure formula for the line. I know how to get this line for a collumn but my line graph is created using a quick measure...