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

 

Measure Created

 

.Test_Registrations PW =
CALCULATE([.Registrations],FILTER(All(vw_PBI_DEVELOPER_JOURNEY_REGISTRATION),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])
))
 
Here are my results and this is what I want, However, None of my slicers are working expect the Year slicer.
The data is from one table and no relationships are needed. 
 
 
 
Need Help

4 Replies

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