Calculate Difference Platform by Row Using Formula

[Anonymous]

Hi, I need to calculate this table data with the formula. This is the formula and table. K is a number of platforms. Initial Estimate Mean(𝜃^) = 98.93455. I will use the value failure rate from TEP-A and TEP-B then need to minus Initial Estimate Mean(𝜃^).

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

Platform(k)          Total Failures(n)           Service Time(τ)              Failure Rate

  TEP-A                           7                             0.07884                          88.78

  TEP-B                           6                             0.05256                         114.15

  Total                           13                             0.1314                            98.93

[AlB · Accepted solution]

@Anonymous 

Measure =
VAR estimateMean_ = 98.93455
VAR K_ =
    DISTINCTCOUNT ( Table1[Platform(k)] )
RETURN
    SUMX (
        Table1,
        POWER (
             ( ( Table1[Total Failures(n)] / Table1[Service Time(τ)] ) - estimateMean_ ),
            2
        ) / ( K_ - 1 )
    )

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous]

GOT IT ! Thank you so much @AlB 👍

[AlB]

Hi @Anonymous 

Not clear. What is the Σ indexing over?

Please show the expected result, explaining the steps in the formula.

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous]