Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
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