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 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)
 
 
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.

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , You need to try like

     

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

  • 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous 

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