Display a table row from others based of combination of selection

[Benefactor]

Hi,

I have a table like that:

Code	Title	Save Date	Percent	Value 1	Value 2
AAAA	Title 1	07/05/2021	20	15	50
AAAA	Title 1	09/20/2021	20	20	25
BBBB	Title 2	01/01/2022	60	25	36
BBBB	Title 2	07/05/2022	60	30	15

I want to display the row of the most recent date based on combinations of selections Code/Title/Percent. 

For example, if I select Code: AAAA, Title: Tilte 1 and Percent 20, I just want to display this row:

Code	Title	Save Date	Percent	Value 1	Value 2
AAAA	Title 1	09/20/2021	20	20	25

Have you an idea in order to perform that ? Thank you !

[Or]

Dimensions: Code, Title

Measures:

Date(Max([Save Date]))

FirstSortedValue(Percent, -[Save Date])

FirstSortedValue(Value1, -[Save Date])

FirstSortedValue(Value2, -[Save Date])

Note: This assumes that there will always be a single line with the most recent save date, and that the save date is an actual date column and not a string formatted as a date.

[Benefactor]

Thanks for replying,

I also want the full table to be displayed if no item is selected as well. First (without selection) I want the first table to be displayed, the second table displays if and only if the combination of selection is matched.

[Or]

You could do this one of three ways:

1) Container object with the object changing based on selections

2) Show/hide condition per field based on the selection

3) If() statements within each measure based on the selection

In all three cases, the first table is just a straight up table with everything being a dimension, near as I can tell, so there's nothing tricky about that. The second table is as in my previous post.