Forum Discussion
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...
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,
1 Reply
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,