cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
maximus12 Frequent Visitor
Frequent Visitor

Filter grid results using selected value from another grid.

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

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-sihou-msft
Moderator

Re: Filter grid results using selected value from another grid.

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

 

 

5.PNG

 

Regards,

1 REPLY 1
Moderator v-sihou-msft
Moderator

Re: Filter grid results using selected value from another grid.

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

 

 

5.PNG

 

Regards,