MAX not giving right result

[samnaw]

Hello:

I have a column in my table called FY. It only has 2020 and 2021. So MAX should result in 2021 and MAX -1 2020. Very Simple. 

But when I try to do MAX its gives me the following result:

Its giving me the total number of rows: 6053315966

I know for sure my data is correct:

This is a problem because when I:

This works

CY_Sales = CALCULATE (

SUM ( VW_DASHBOARD_SALES[Sales]),

FILTER ( 'VW_DASHBOARD_SALES','VW_DASHBOARD_SALES'[FY] = 2021),

FILTER ( 'VW_DASHBOARD_SALES', 'VW_DASHBOARD_SALES'[loyalty_flag] = "CARD" ) )

But this doesnt

CY_Sales = CALCULATE (

SUM ( VW_DASHBOARD_SALES[Sales]),

FILTER ( 'VW_DASHBOARD_SALES','VW_DASHBOARD_SALES'[FY] = MAX('VW_DASHBOARD_SALES'[FY]) ,

FILTER ( 'VW_DASHBOARD_SALES', 'VW_DASHBOARD_SALES'[loyalty_flag] = "CARD" ) )

[amitchandak]

@samnaw , it should have worked, unless you have used the wrong table or column. Difficult to tell without looking at data. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.