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

[Shaundekok]

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

[Anonymous · Accepted solution]

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.