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
I tried explaining it below the second point. I know it always make sense in my head but not for the rest. 🙂
This is what I get with the average formula. The correct value should be 31M divided by 26 weeks (around 1.2M).