Filtered max in multiple columns then Sum of 4th column

[Jo1245]

Good day

I am brand new to Power BI and trying to create the measure below:

I am trying to create a measure by using the table "Sampledata" below and filtering max in "Year(fiscal)" column, and filtering max in "Month(period)" column, and filtering by "Check[In Scope]" column then sum "$" column. The answer should be 711242.80

Sampledata Table

Product division	$	Check	Month(period)	Year(fiscal)
Frozen	1185.98	In Scope	10	2022
Frozen	14596.32	Out of scope	9	2021
Frozen	178.61	In Scope	10	2022
Frozen	521.8	Out of scope	11	2021
Dry	123409.2	In Scope	10	2022
Dry	1325.94	Out of scope	9	2022
Dry	22.8	Out of scope	9	2021
Frozen	6487.3	Out of scope	10	2022
Frozen	557566.2	In Scope	10	2022
Dry	12015.16	In Scope	10	2022
Dry	8071.98	In Scope	10	2022
f	44.14	In Scope	10	2022
Dry	8771.6	In Scope	10	2022

This is what the table looks like in excel with the filters:

thank you

[amitchandak · Accepted solution]

@Jo1245 , Better to have new column like

Year Month = [Year]*100 +[Month]

Measure = calculate(Sum(Table[$]), filter(Table, Table[Year Month] = maxx(allselected(Table), Table[Year Month]) ) )