Power BI Dax for aggregated average calculation

[Anonymous]

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.

[amitchandak · Accepted solution]

@Anonymous , 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

[Anonymous]

@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?