Set Analysis Formula with 2 Measures

[joshdellapietro]

Hello, 

I want my formula to filter on max Year (2020) and then filter on the max month for 2020, which is 4 (April). The first part is picking up 2020, but since I have 2019 loaded, the max month function is picking up 12 (December).

Here is what I am currently using: 

Sum({$<[Year]={$(=(Max([Year])))},[Month #]={$(=Max([Month #]))}>}[PY Net Sales])

My data looks like this:

Year	Month #
2019	12
2020	1
2020	2
2020	3
2020	4

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

Sum({<Year={"$(=Max(Year))"}, [Month #]={"$(=Max({<Year={"$(=Max(Year))"}>} [Month #]))"}>} [PY Net Sales])

[joshdellapietro]

This worked perfectly, thank you!