Standard Deviation Calculation that adjusts with filters

[Anonymous]

I have the following calculation for standard deviation:

STANDARD DEVIATION =
CALCULATE ( STDEV.P ( QA[TIME AT DESTINATION] ), ALL ( QA ) )

This is a measure that calculates the standard deviation of "TIME AT DESTINATION" for the entire population of my data.  However, I want this number to adjust as I filter data.  If I have a slicer and filter by a specific customer, I want to display only the standard deviation for that customer.  

Any help would be appreciated.  Thank you.

[MFelix · Accepted solution]

Hi @Anonymous,

When you add a ALL to your formulas it gets all the information removing the slicer from the filters.

In this case you should use the measure like this.

STANDARD DEVIATION = CALCULATE ( STDEV.P ( QA[TIME AT DESTINATION] ))

Regards,

MFelix

[Anonymous]

Excellent.  I thought it would be something simple.