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
Hey Basti76 ,
pls show me what you mean by "But if I leave it open with all the outcome is incorrect".
Which other additional filter do you use?
Sorry for the unclear explanation. If I would add a filter and only look at the average for one item I get the same result. If I don´t filter on item level (using a slicer) I don´t get the correct result.