Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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.

indexweekvalueresultexpected result
111014.2030
211025.2030
311050.2130
421021.2320
521022.2120

Thanks,
Pra137

  • Anonymous 

     

    Please try this

    column = CALCULATE(sum(Sheet22[value]),FILTER(Sheet22,Sheet22[week]=EARLIER(Sheet22[week])))

2 Replies

  • Anonymous 

     

    Please try this

    column = CALCULATE(sum(Sheet22[value]),FILTER(Sheet22,Sheet22[week]=EARLIER(Sheet22[week])))