cancel
Showing results for
Did you mean:
Regular Visitor

## How to Calculate Variance (Query)

Hi, I still new to power bi. I need to calculate this table data with the variance formula, but I get an error. This is the formula and table. K=2. Initial Estimate Mean(𝜃^) = 98.93455 (I create measure = 98.93455). This is my query

Variance = POWER(SUM('Table'[Total Failures (n)])/SUM('Table'[Service Time (τ)])-('Table'[Measure]),2) / SUM('Table'[Machine(k)])-1

Variance Formula = ((n/τ)-𝜃^)^2 /(k-1)

Machine(k)           Total Failures(n)         Service Time(τ)
TEP-A                             7                            0.07884
TEP-B                             6                            0.05256

1 ACCEPTED SOLUTION Solution Specialist

Hi, @2016725975 ,

You can use  VARX.S()

``````Column = DIVIDE(Total Failures,Service Time)
Measure = VARX.S('Table','Table'[Column])``````

Mark this post as a solution if this helps! Solution Specialist

Hi, @2016725975 ,

You can use  VARX.S()

``````Column = DIVIDE(Total Failures,Service Time)
Measure = VARX.S('Table','Table'[Column])``````

Mark this post as a solution if this helps!   