Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.