Filter out the last three known weeks and the total of all weeks does not decrease

[pietshort]

Example Table 1:

Column A	Column B
Week 1	2
Week 2	5
Week 3	4
Week 4	3
Week 5	1
Week 6	4

In table 1 I want to perform a filtering. Column A contains the weeks (alpha number, no time intelligence) and column B contains the values. If I filter by column A on the text value week 1, week 2, week 3, I want week 4 to add these values from week 1t/m3. So that the volume does not decrease in the weeks but in the "visual" the weeks are no longer visible.

Outcome of Table 2:

Column A	Column B
Week 4	14
Week 5	15
Week 6	19

In the end, I want a meausure to filter out the last three known weeks and the total of all weeks does not decrease. Like Table 2 above.

Thank you in advanced 

[v-zhangti]

Hi, @pietshort 

You can try the following methods.

ColumnC = CALCULATE(SUM('Table'[ColumnB]),FILTER('Table',[ColumnA]<=EARLIER('Table'[ColumnA])))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pietshort]

Hi Charlotte,

This is the solution in a calculated column but i would like to have it in a measure.

[v-zhangti · Accepted solution]

Hi, @pietshort 

You can try the following methods.

Measure = CALCULATE(SUM('Table'[ColumnB]),FILTER(ALL('Table'),[ColumnA]<=SELECTEDVALUE('Table'[ColumnA])))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.