Skip to main content
cancel
Showing results for
Search instead 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

New Member

## Power BI Dax for aggregated average calculation

Is there a way to calculate average(Column F) like this? Need to calculate Expression 3 for each product category/sub-category combo and then take average of those. Please note that the average calculation should interact with slicers(eg: calendar dimension(product launch date), product category and product sub-category slicers. I need this average value to be added as a straight line in a line chart where the x axis is product category/sub-category combo and one line value is expression 3 and the second line value is average calculation. Something like below graph. Where the yellow straight line is avarage and grey line is Expression 3.

1 ACCEPTED SOLUTION
Super User

@lintotom , You need a measure like

calculate(Averagex(Summarize(Fact, Product[Product], Product[Sub Category]), calculate(Sum(Fact[Value])) ), allselected() )

example

Avg of Sum : https://youtu.be/cN8AO3_vmlY?t=22980

2 REPLIES 2
Super User

@lintotom , You need a measure like

calculate(Averagex(Summarize(Fact, Product[Product], Product[Sub Category]), calculate(Sum(Fact[Value])) ), allselected() )

example

Avg of Sum : https://youtu.be/cN8AO3_vmlY?t=22980

New Member

@amitchandak Thank You. One more additional requirement. right now Column F is calculated as Average of expression 3 for each sub category. How can we calculate the same with one additional filter. ie, Average of expression 3 for each sub category where expression 3 value should be above 20. In the above example, Average should be (25+25)/2 = 25. Is this possible?

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors