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"
)
)
First of all, I want to thank you both. Practically, both solutions get the job done for me.
Daniel29195 this solution with sumx is what I needed at start, It solves "mby with propper DAX formula, I can retrieve values for days and weeks in one, but not certain" this part. Now I need one measure less to get the result 🙌
Ashish_Mathur If I underestood correctly, basically you did this "So if I had possibility to add Average on Total Availability Measure it would be great" with your Measure = averagex(values(Calendar[Date]),[Total availability Daily Line1])!! Thanks a lot man, you have learned me a really important thing 👍
You are welcome.