Forum Discussion

maximus12's avatar
maximus12
Frequent Visitor
9 years ago
Solved

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 nam...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    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,

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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,