Forum Discussion
Calculate Total Availability per Line Weekly
if you need the sum of minimum,
then change planned production time measure to :
sumx (
values ( date ) ,
calculate (
min ( failure_rates_data[planned production time]),
failure_rates_data[line] = "Line1"
)
)
Hello
it seems the number you want to achieve is equal to ( lets say Wk45) , the( sum (of planned production Timeline1) - sum ( total line 1 lost production time )) / sum (of planned production Timeline1)
to solve your problem try this :
planned production time line 1 = replace min with sum () ,
this way you will have :
at the wk45 :
((510 + 510 + 510 + 450 ) - 165) / (510 + 510 + 510 + 450 ) = 91.5%
hope this helps
if you need the sum of minimum,
then change planned production time measure to :
sumx (
values ( date ) ,
calculate (
min ( failure_rates_data[planned production time]),
failure_rates_data[line] = "Line1"
)
)