Forum Discussion
Help to find Standard Deviation
If you created the average as a quick measure, it should give you the formula still.
Check out my post on Primary and Secondary School Performance for Ohio. It includes the PBIX file and the calculation of standard deviation was central to the project:
Should be able to download the PBIX and see how I did it.
Looks like I just used STDEV.P function
Overall Score District StdDev = STDEV.P(DISTRICT[OVERALL SCORE])
https://msdn.microsoft.com/en-us/library/gg492207.aspx
Thank you!
The challenge here is I need to find standard deviation for a measure which is a quick measure to calculate 3 months rolling average.
I think the solution would be creating it as a calculated measure. Is it possible?
Ah, it sounds like you are trying to do an aggregation. The trick there is to use SUMMARIZE. See this article:
https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
A quick measure still creates a real measure, it just does it quickly without you having to hand-type the DAX code.