Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

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. 
 
Last Week Metric.PNG
 
 
4 REPLIES 4
amitchandak
Super User
Super User

Can you remove all vw_PBI_DEVELOPER_JOURNEY_REGISTRATION and test

FILTER(All(vw_PBI_DEVELOPER_JOURNEY_REGISTRATION)
Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

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

 

 

Last Week Metric 2.PNG

 

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

 

Last Week Metric 3.PNG

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

 

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.

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors