So the main problem is that I would like to show the average numbers per Week numbers. But I don't know why but it sums up all the averages, and not just average the averages.
My current DAX formula:
Average =
AVERAGEX(
FILTER('Code',Code[Code_name] = "Failure"),
CALCULATE([Time])
)
Where Time is another Measure.
you can see that calculating the average by ID works, but if you collapse the matrix it shows weird numbers per week number. Any advice?
