Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Need Explanation

Hi Team, Need explanation in detail  why my formula is not working the way it was built and please find my PBIX file in below link. I have created a measure to calculate two weeks Rolling average of...
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks a lot for solution but i have below question, please clarify me?

1. My assumption is once we have relation between tables and  apply the filter, it will apply to whole model right, if yes ,then why my filter WeekNum from any table not filtering another weeknum in different table. Please explain me if i am missing something.

2. If you see my below formula(1) .For the variables   Last12Weeks, Last12Weeks2 i am not assigning to any column so i don't understand how its still working. 

1.

CALCULATE ( [Sales], Last12Weeks,Last12Weeks2 )

2. normal way of filtering:

CALCULATE ( [Sales],

CALCULATE ( [Sales],FactValue[WeekNum] =201801)