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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper III
Helper III

Use a measure to Filter a table that filters other tables

I have a table with Sales reps and their targets but at different times they receive updated rates and there are a few who have left the company. I am managing those using a start date and end date column however I need to use these columns to filter the Sales rep table based on the selected date range in the slicer from the calendar table. 

This should also filter other tables that it is connected to in the data model.


Can this be achieved using a measure? The aim is to show historical data when the user selects a date range where the start and end date falls in. If the date is not in the range then they are filtered out. 

Super User
Super User

@Sagejah9 , seem like an scd problem, check if these can help


Guyinacube -




If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.