Forum Discussion

Shaundekok's avatar
Shaundekok
New Member
5 years ago
Solved

Filter 2nd Table (Visual) based on 1st Table (Visual)

Hi,

 

I have been stuck on the following problem for a few days.

 

I have 2 tables on a page, the data comes from the same imported DB Table (Sheet1):

 

Table 1

Table 1

Table 2

Table 2

I need to be able filter table2 based on a selection from table 1. It should return the the rows where that Date and Location are the same, i.e. if you select the row with name 3 from Table 1, it should return the rows with Name 1 & Name 3.

 

I have tried to create a measure to filter this:

FilterTest = CALCULATE(COUNTROWS(Sheet1),ALL(Sheet1[Full Name]), All(Sheet1[Status]))
It does return the correct number of record, but when you click the record in Table 1, it only displays the same record in table 2.
 
Any ideas?
 
Many Thank
Shaun

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Shaundekok ,

     

    Based on your description, you can create a measure as follows.

    Measure = 

    var x1=SELECTEDVALUE('Table1'[Date])

    var X2=SELECTEDVALUE(Table1[Location])

    return

    IF(MAX('Table2'[Date])=x1&&MAX('Table2'[Location])=X2,1,0)
    Result:
     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Shaundekok ,

     

    Based on your description, you can create a measure as follows.

    Measure = 

    var x1=SELECTEDVALUE('Table1'[Date])

    var X2=SELECTEDVALUE(Table1[Location])

    return

    IF(MAX('Table2'[Date])=x1&&MAX('Table2'[Location])=X2,1,0)
    Result:
     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.