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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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