REQ help to get the value of the sum of only the last selected year and month

[Invisibleman]

Dear all,

I'm sorry to bother you again. But I am trying to get some listing by selecting the date and the year. Which is no problem and it's working. Further do I have a selection where I can get the result in the EUR or USD, also this is no problem.

The problem I have, is that when I made the year and month selection, beside the listing, I also want only the value on the year & month that I selected. Also then with the selection of EUR or USD. And this I don't get to work. When I make the selections, this will then adding up all the selected periods, and not only the last selected year & month. Which I do have also a measure for and those also are workin. Only the sum formula to get this to work I can't seem to get. 

The result of the last value I will need to display but also need to use in other calculation to add up where needed.

If anybody could help me, that would be very appriciated.

This is the test pbix I created 

This is the test excel file I am using 

Thanks in advance,

With regards,

Hans

[ShirinArshadnia]

Hi @Invisibleman 

try to use keepfilters or selectedvalue in your dax query 

for further help please  visit the link below:

https://learn.microsoft.com/en-us/dax/filter-functions-dax

[Invisibleman · Accepted solution]

Hello ShrinArshadnia,

Thanks for the reply I did try and both didn't work. For teh KeepFilter I didn't notice the difference  with the regular Filters. The selectedvalue, did work partly with the year, but only when I have selected 1 year, as when selecting multiple years, the vale was showing (Blank) and I do need the option to select multiple years

But I think I found what I need; 

BestForYEAR3 = CALCULATE(sumx(TestSheet,[-SwitchBackOrderEURUSD]),FILTER(TestSheet,TestSheet[Year] = max(mapCalendar[Year]) && TestSheet[Month] = max(mapCalendar[Month])))

This also works with the measure -SwitchBackOrderEURUSD.

Anyway thank you very much that you did make the time to reply and to help me to find the solution.

Regards,

Hans