Average calculation Filtered

Hi Anonymous 

I think you have turned off "Keep all filters" function in Report Tooltip Page. 

This will cause your Tooltip show Sales Avg based on all months. I think 29722613 is the average of sales based on all months.

Still keep this function turned off, and use sync slicer based on the Month Slicer in your Report Page.

For reference: Sync and use slicers on other pages

Now we can get the correct result 25,338,083.5.

For more details, you can download my sample file. 

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.