Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Average calculation Filtered

Hi,   Can someone help me with this filter of this measure.   I have this average calculation that counts the dynamic denominator and it works in a table, but I want grab this total and put it in...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.