Forum Discussion
Solved
Average from table with slicer from second table
I have two slicers. Year and Week of year. I would now like to calculate a total average of stock value for the selected period. I have two tables. 1. Calendar table with individual dates, week ...
Yes, I did´t considered this case so far...difficult ro cover your need without knowing your datamodel.
Easy to solve.
Divide 2 measures.
AVG = SUM(your_table[Amount Item]) / DISTINCTCOUNT(your_table[WeekNumber])
Try this approach.
Hope you can adjust the idea to your model
Ok, then check your datamodel. Something seems not correct.
My small model works fine with filter on item.
K22:
M55:
In the first screen the total is 83 for 26 weeks. So, shouldn´t it be 83/26 = 3.19? That would be the sum of the two. But yours shows 1.6. Which would be the average of the 2.0 and 1.2.