Skip to main content
cancel
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.

Reply
Sagejah9
Helper III
Helper III

Use a measure to Filter a table that filters other tables

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

1 REPLY 1
amitchandak
Super User
Super User

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

 

SCD
Guyinacube - https://www.youtube.com/watch?v=tKeaQpWynzg

https://www.youtube.com/watch?v=E1ZABKBpkdg

https://www.zartis.com/scd-implementation-with-temporal-tables-in-power-bi/

 

else

 

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

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.