Sum of average by week

[FRG]

Hello,

In my report I created a measure to calculate the average of the 2 best weeks of purchase in the last few years, which it works.

Opt = 
var wt = year(today())*100+weeknum(TODAY(),1)
return  if (SELECTEDVALUE(DimDate[Year/week])<wt,BLANK(),
 var w= SELECTEDVALUE(DimDate[#Week])
 var a= SUMMARIZE(FILTER(ALL(DimDate),DimDate[#Week]=w),DimDate[Date].[Année],"Purch",[Purchase])
  var b = topn(2,a,[Purch],DESC)
 return AVERAGEX(b,[Purch]))

Now I need a measure to sum these average like this.

How can I acheive this?

Thank you

PBIX file:

https://www.dropbox.com/s/6p0a7wgs23uwq3z/Test_purchase.pbix?dl=0 

[Seanan]

Hi @FRG,

This post here might be able to help you achieve the cumulative sum that you are looking for.

If this helped you solve your problem, please mark it as the solution.

Kind regards,
Seanan.

[FRG]

Hello, thanks for the reply.
I can't create a calculated table to achieve this because I have to many thing that can filter the result. I'm still searching for a calculated measure.

Thank you