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

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?