Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

undefined

I am trying to calculate values for the previous week. Currently I am getting the values I want however my measure is not being filtered by any of the slicers that I choose. Below is my measure and r...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

All from the same table. Put all on week_number and event year at the start. and test.

amitchandak's avatar
amitchandak
Super User
6 years ago

 

CALCULATE([.Registrations],FILTER(All(vw_PBI_DEVELOPER_JOURNEY_REGISTRATION[EVENT_YEAR]),All(vw_PBI_DEVELOPER_JOURNEY_REGISTRATION[WeekNumber]),vw_PBI_DEVELOPER_JOURNEY_REGISTRATION[.WeekNumber] = SELECTEDVALUE(vw_PBI_DEVELOPER_JOURNEY_REGISTRATION[.WeekNumber]) - 1 &&
vw_PBI_DEVELOPER_JOURNEY_REGISTRATION[EVENT_YEAR] = SELECTEDVALUE(vw_PBI_DEVELOPER_JOURNEY_REGISTRATION[EVENT_YEAR])
))

If this does not work, please provide a sample.