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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
kkanda
Resolver II
Resolver II

Sub table does not get filtered with dates

I have a large table with 35 K records starting from a date in year 1990 until today. I want to create a subtable from the main table with filtered dates which are decided by a variable slicer for dates. I am using the measure:

Sub_ZIOC =
CALCULATETABLE(ZIOC_June30, DATESBETWEEN(ZIOC_June30[Malfunction start], Dim_Date[Min_SelDate], Dim_Date[Max_SelDate]))
where the ZIOC_June30 is the main table and Sub_ZIOC is the subtable. Min_SelDate and Max_SelDate are measures created from the slicer for dates. I expected the number of rows to vary for Sub_ZIOC as I change the date range of my selection on the slicer. This is not happening. If the main table has 35K records, the subtable remains constant at 6K+ records irrespective of the selection of the date range. I did not establish any relationship between the date table and the main table. I tried setting the same date format for the Min_SelDate, Max_SelDate and the [Malfunction start] date. But it does not work.
I cannot understand why it is happening. How can I make this dynamic filter work to get a subtable with varying number of records. 
Thank you
1 REPLY 1
kkanda
Resolver II
Resolver II

It looks like the subtable is getting filtered between the Start and End dates of the slicer, but does not respond to the selected Max and Min dates, as varied by the slider. When I get the Max and Min dates on two cards, they do vary when I move the slider. But the subtable is not affected. This is puzzling. 

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.