Show values from different rows in one row based on two slicers selection

[mda]

I have a Table with those columns: Country, Year, Value.

I also have two slicers - on each of them I can select only one year.
Both of this slicers are using Year columns from two different tables Years1, Years2 created as:

SUMMARIZE(Table; Table[Year]).

Now I want to show a table with those values:

Country, Value for year from the first slicer, Value for year from the second slicer

I can read slicer selected value, but it can be accessed only in a measure like this:

Selected Yea 1r = IF (
   ISFILTERED ( Year1[Year] ) && HASONEVALUE (Year1[Year] );
   LASTNONBLANK ( Year1[Year]; 0 );
   2017
)

The problem is that I can't use in any table join or filter

So I don't know how to do solve this problem.

Can anyone help?

Thanks,

Marcin

[v-sihou-msft]

@mda

In Power BI Desktop, the calculated table is evaluated before you take selection in slicer. So you can dynamically show the values via measure based on the selection in slicer. And since you don't have relationships between the source table and those two year tables your measure will always show the last non blank value in year table. 

Regards,

[mda · Accepted solution]

Yes, I figured it out.
Instead of that, I self-joined that table and after that, I had all combinations and now filtering is possible.

Marcin