cancel
Showing results for
Did you mean:
Resolver II

## Get value from two filters

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] )
)
)```

1 ACCEPTED SOLUTION

Accepted Solutions
Community Champion

## Re: Get value from two filters

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] )```
2 REPLIES 2
Community Champion

## Re: Get value from two filters

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] )```
Resolver II

## Re: Get value from two filters

@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))`

Announcements

#### ‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors