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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Colinr
New Member

Help to convert hard coded Dax filter to use current selection values

I have a Dax filter that correctly filters to hard coded values, How can I change this to use the Filters of the current PBI visualisation page filter selection, Id also like the Date to use the  SAMEPERIODLASTYEAR() for the date filter ?

 What I have so far is :

 

 

previousYear = CALCULATE (
SUM ( 'vw Monthly Milk Production'[value] ),
FILTER (
All('vw Monthly Milk Production'),
'vw Monthly Milk Production'[adjustment] == "30 Day adjustment"
&& 'vw Monthly Milk Production'[Type] == "Natural Content"
&& 'vw Monthly Milk Production'[country] == "United Kingdom"
&& 'vw Monthly Milk Production'[date] == value("2020-02-01")
)
)

 

 

1 REPLY 1
Colinr
New Member

Ive got a bit further with below, but the sameperiod last year function, returns an empty filed in my pbi table,  What Do I need to do to provide this expression with the correct context please ?

 

 

 

previousYear = CALCULATE (
SUM ( 'vw Monthly Milk Production'[value] ),
FILTER (
ALLSELECTED('vw Monthly Milk Production'),
'vw Monthly Milk Production'[date] == SAMEPERIODLASTYEAR(Dates[Date].[Date])
)
)

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.