date filter - joined tables

[fiorela]

Hi guys, 

I have two tables joined by URL:

Table1

date	url	User	Category
3/26/2020 18:30	ht//hello	juan	A
2/2/2020 17:15	ht//goodbye	peter	B

3000 rows like this with different users.

Table2

date	url
3/23/2020 18:30	ht//goodbye
3/10/2020 17:15	ht//hello

and I would like filter a table (or matrix) by Date of Table2 (is on or after 3/23/2020). i.e, I would like to see all users (table1) that have a particular URL after 3/23/2020 (table2).

I've put the field in filter pane, but it doesn't work. It appears that "is on or after" doesnt filter the date as I want. It only show one rows. 

Any suggestions? 

Thanks in advance!! 

[v-frfei-msft]

Hi @fiorela ,

We can create a measur as below and make the table visual filtered by it.

Measure = 
VAR seled =
    SELECTEDVALUE ( 'Table (2)'[date] )
VAR ur =
    MAX ( 'Table (2)'[url] )
RETURN
    IF (
        MAX ( 'Table 1'[date] ) >= seled
            && MAX ( 'Table 1'[url] ) = ur,
        1,
        BLANK ()
    )

Pbix as attached.

[fiorela]

sadly it didn't work. In your example, the date 3/26/2020 should even appear and it does not. Thanks anyway for your time.

[parry2k]

@fiorela I guess in your relationship Table2 is on one side of the relationship, correct?

[fiorela]

yes, correct !