cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## Average values then sum subtotal and grand total

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?

1 ACCEPTED SOLUTION
Microsoft Employee

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

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

2 REPLIES 2
Microsoft Employee

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

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

Helper II

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

Thank you sir, marking as solution.