Average values then sum subtotal and grand total

[Quinnie2017]

Hi Everyone - I've averaged a value but I want to sum the averages in my subtotals and totals.

Example dataset

Example pbix

Can you help?

[mahoneypat · Accepted solution]

I would encourage you to add a separate Date table, instead of using a Date Hierarchy, but below is a measure expression that sums the averages.

Avg Impact =
SUMX (
    SUMMARIZE ( MASTER, MASTER[Date].[Year], MASTER[Date].[Quarter] ),
    CALCULATE ( AVERAGE ( MASTER[Impact%] ) )
)

Pat

[Quinnie2017]

@mahoneypatholy cow did Patrick Mahomes just reply to my PowerBI question?!?!?!?  LOL

Thank you sir, marking as solution.