Forum Discussion
Anonymous
6 years agoNot applicable
Ignore the Row Context filter By Week
Hii Guys, I have calculated Actual & Plan Difference , I want to add this difference into other measure i.efor week 1, Actual =40, Plan =20 ,i.e 40-20=20 & week=2 actual = 20 ,plan =10 i.e 20-10 =10 i want to add this 20 and 10 to another column and this difference filter by week ,when add this into a measure this 20 and 10gets filtered by row by row, i want result like below expected result colum .please help me how to ignore this row context.
| index | week | value | result | expected result |
| 1 | 1 | 10 | 14.20 | 30 |
| 2 | 1 | 10 | 25.20 | 30 |
| 3 | 1 | 10 | 50.21 | 30 |
| 4 | 2 | 10 | 21.23 | 20 |
| 5 | 2 | 10 | 22.21 | 20 |
Thanks,
Pra137
Anonymous
Please try this
column = CALCULATE(sum(Sheet22[value]),FILTER(Sheet22,Sheet22[week]=EARLIER(Sheet22[week])))