Forum Discussion
Calculate average variance
- 1 year ago
I think we have different understanding of what Variance means.
Variance is the expected value of the squared variation of a random variable from its mean value, in probability and statistics. Informally, variance estimates how far a set of numbers (random) are spread out from their mean value.
The value of variance is equal to the square of standard deviation.
Based on your sample data here is the variance of the individual groups
If you want the average of the variance then you need to "Think like the Grand Total" and materialize the variances for all groups.
variance = var a = ADDCOLUMNS(SUMMARIZECOLUMNS(MyTable[ID ],MyTable[Item ]),"v",CALCULATE(var.p(MyTable[Price]))) return AVERAGEX(a,[v])
Hi nok,
Thank you for reaching out to Microsoft Fabric Community.
Thank you lbendlin and Ashish_Mathur for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue?
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Thanks and regards,
Anjan Kumar Chippa