Max Function within Calculate

[Anonymous]

I have a page that has several measures and visuals that uses a Report Period filter. For this example I have the page filtered on report period 201810, 201811, and 201812. Within this page I am using the swap rate, for which I have a seperate table which I have linked to the other data table. I essentialy want this measure to only use the highest swap rate, in this case, 201812, and not the sum of the 10,11, and 12, which it is currently doing.

CALCULATE(SUM('Swap Rates'[2_Yr_Swap]),'Swap Rates'[Report_Period]=MAX('Swap Rates'[Report_Period]))

[Anonymous · Accepted solution]

I read another post that solved this using filter before using max

CALCULATE(SUM('Swap Rates'[2_Yr_Swap]),FILTER('Swap Rates','Swap Rates'[Report_Period] = MAX('Swap Rates'[Report_Period])))