Average calculation Filtered

[Anonymous]

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 a tool tip for when you hover over the different numbers it calculates the average based off the amount of non blank values. The average calculation works, but can I not grab this total? I feel I am not filtering it correctly.

I have the calculation, I want to be able to put this calculation to dynamically slicer in a slicer, take the average of the group selected. Also, have a tool tip that allows you to hover over a subgroup item of the group selected and get the average.

In the Tool tip the "Sales $ CY, Avg Sel" ---- Should be $25,338,084 returned from the measure in the Table.

Thanks!!

Should be 25K for Sales $ CY, Avg Sel

Here is my Average Calculation

Sales $ CY Avg. =

var countD = COUNTax(Team Number,[Sales $ CY])

return

DIVIDE([Sales $ CY],countD,0)

[Anonymous]

Hi @Anonymous 

Thanks for getting back to me. It definatly is some filter that I am trying to navigate between the Tooltip & Main page.

[Anonymous · Accepted solution]

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.

[amitchandak]

@Anonymous , You need to try like

Sales $ CY Avg. =
var countD = COUNTax(Values(Table[Team Number]) ,[Sales $ CY])
return
DIVIDE([Sales $ CY],countD,0)