How to filter a graph visual only using select columns from a table visual?

[P_BI_Noob]

I have a table and graph visual that looks like the following:

I want to be able to do 2 things:
1. Only display the latest row for each distinct F, M and L Names. This is starightforward and I know how to accomplish

2. Using that filtered table, be able to click a row and show the full history of payments for each distinct F, M and L Names

Here is what I have attempted thus far:
1. The table visual uses dataset Table1, the graph visual uses

Table2 = CALCULATEDTABLE('Table1')

2. I created a measure that looks like the following 

Measure 2 = 
VAR att = SELECTEDVALUE(Table1[F Name])
VAR att_2 = SELECTEDVALUE(Table1[M Name])
VAR att_3 = SELECTEDVALUE(Table1[L Name])
VAR btt = MAX('Table2'[F Name])
VAR btt_2 = MAX('Table2'[M Name])
VAR btt_3 = MAX('Table2'[L Name])
RETURN
IF(ISBLANK(att) && ISBLANK(att_2) && ISBLANK(att_3), 1, IF(att_2=btt_2 && att=btt && att_3=btt_3, 1, 0))

The measure works if I only use F name (att and btt) as the table visual columns I want to filter on, but when I add the M and L Name variables, the measure stops working, please advise

[amitchandak]

@P_BI_Noob , Create these measure and user

Last Qty = Var _max = maxx(filter( ALLSELECTED(Data1), Data1[M Name] = max(Data1[M Name]) && Data1[F Name] = max(Data1[F Name]) && Data1[L Name] = max(Data1[L Name]) ),Data1[Date])
return
CALCULATE(sum(Data1[payment]), filter( (Data1), Data1[M Name] = max(Data1[M Name]) && Data1[F Name] = max(Data1[F Name]) && Data1[L Name] = max(Data1[L Name]) && Data1[Date] =_max))

Sum Last Qty = sumx(VALUES(Data1[ID]) , [Last Qty])

Latest Date
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...

[P_BI_Noob]

Thank you for the response, however I do not believe this fully answers my question. I want the table visual to display the latest payment AND I want the graph visual to display the full history of payments once I select the latest payment from the table visual.

When I select a latest payment from the table visual currently, the graph visual is filtered down to only the latest payment and not the full history of payments

[Anonymous · Accepted solution]

Hi @P_BI_Noob 

Do you hope to realize something like this? When selecting a row, the line graph should show the payments of the specific person?

I create a measure [# Payment] to get the latest payment. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[P_BI_Noob]

Yes this is exactly what I wanted to accomplish, I did not include the date in my original table and thus did not use the latest summary option which led to my problems. Thanks for the example!