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

Can you remove all vw_PBI_DEVELOPER_JOURNEY_REGISTRATION and test

FILTER(All(vw_PBI_DEVELOPER_JOURNEY_REGISTRATION)
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Here I removed All, however, I did not get any data

     

     

     

    Here I tried All Selected. I did get the proper results and I am also able to filter the data. 

    The challenge here though, is now I am not showing any data for the first week in the matrix. Smh

     

    • 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.