Filter grid results using selected value from another grid.

[maximus12]

apologies if this is easy stuff, but I'm new...

I have two unrelated tables so I can't build a relationship to enable cross-grid filtering..  so...

Top grid has a table of dates and event names.  I'm using the table preview visual so I can select a row in this grid.

The bottom grid links to a second table has a range of dates (start Date and End Date).  By default bottom grid currently shows all rows because there is no obvious relationship, but what I want to do is set up a filter that says only show rows  WHERE (date selected in Top grid is BETWEEN startDate and EndDate)..  

Is there a DAX expression I can use for filtering the bottom grid based on what's selected in the top grid?  (again, using the preview data table visualization)..

thx..

M...

[v-sihou-msft · Accepted solution]

@maximus12

You can create a measure in Table 1 for "Selected Date".

Selected Date = MAX('Calendar'[Date])

Then create a "Tag" measure to check if current row date range cover the "Selected Date".

IsWithinRange = IF([Selected Date]>=CALCULATE(MAX(Duration[StartDate])) && [Selected Date]<=CALCULATE(MAX(Duration[EndDate])),1,0)

Add above measure into Visual Level Filter, make it equals to 1.

Regards,