Get value from two filters

[Anonymous]

Hi,

I'm trying to create 2 filters in a measure to use in my card label. The porpose is to select a month (for example Fev), get the SUM of the "Quantidade Tons", filtered by the column "Estado Ano" that have "Current", and simultanialy it calculate the SUM of Jan+Fev.

If I remove the First filter, they work almost fine... I've the calculation without the "Current" filter. But, if I use the following code, I just have the values without the calculation (Jan+Fev). 

How can use the two filters together?

Consumo de clientes Tons Current Year = 
CALCULATE (
    SUM ( 'OINV E ORIN'[Quantidade Tons] );
	FILTER ('OINV E ORIN';'OINV E ORIN'[Estado Ano]="Current");
    FILTER ( 
	ALL(
       'Calendar'[Date]);
        'Calendar'[Date] <= MAX ( 'Calendar'[Date] )
    )
)

[Anonymous]

@Sean, thank you! It works like a charm with current year. I also use your code to use "last" year.

Consumo de clientes Tons Previous Year = CALCULATE(SUM('OINV E ORIN'[Quantidade Tons]); DATEADD(DATESYTD(Calendar[Date]);-1;Year))

[Sean · Accepted solution]

Okay I'm just guessing here you want a Year-To-Date Total

Does this give you what you are looking for?

Consumo de clientes Tons Current Year =
TOTALYTD ( SUM ( 'OINV E ORIN'[Quantidade Tons] ); 'Calendar'[Date] )