Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Hi @schwinnen,
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @schwinnen,
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsExcellent. I thought it would be something simple.