Standard Deviation by Customer/Weekend Date

[ABCpa]

New to Power BI/DAX and appreciate any guidance.  I'm trying to create a standard deviation measure that will change based on my level of detail in the visual.  I've created a mean calculation that works correctly, but I am unable to get the standard deviation measure to show correctly.  Below is the forumula I'm using for the mean calculation.

Mean Calc =
AVERAGEX(
 KEEPFILTERS(VALUES('Sheet1'[Customer])),
 CALCULATE(AVERAGE('Sheet1'[Measurement]))
)

Any help would be greatly appreciated

[v-chuncz-msft · Accepted solution]

@ABCpa,

You may try to use STDEVX.P Function.