aggregation in drill through page but ignore specific filter

[PowerBIOrg]

Dear all, not sure if the following works.

I have a chart of cost by date with average of selected period (red line).

I have a drill through page with "Date" column. It will list all the claim no and cost.

How can I have the red line value (Report page) in my drill through page (Claim List page)?

Thank you. 

[joaoribeiro · Accepted solution]

Hi @PowerBIOrg , is the AvgCost a measure that you created to show the red line?

• If so, have you tried just adding that measure to the table in the drill through page?
• If not, try creating a measure for the average and add it to the table in the drill through page (use REMOVEFILTERS to get the average among all categories/dates).
  
  
  Hope this answer solves your problem!
  If you need any additional help please @ me in your reply.
  If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
  
  Thanks!
  
  Best regards,
  Joao Ribeiro