Forum Discussion

curtismob's avatar
curtismob
Helper IV
3 years ago
Solved

Variance From Average

Hello. I am trying to find the variance of a measure (SUM), from an average measure of the sum.  Below is some simple data. Product Area Cost Product1 Area 1 10 Product1 Area 2 15 ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    Write these measures

    C = SUM(Data[Cost])
    Average product cost = AVERAGEX(ALL(Data[Area]),[C])
    Variance = [C]-[Average product cost]

    Hope this helps.

curtismob's avatar
curtismob
Helper IV
3 years ago

I apologize, below is a better representation of the desired result.