Calculate and two filters

[Julia_Mav]

Hi all,

I want to get the values of yesterday's sales from country USA. To do that, I tried the measure below:

For yesterday =

CALCULATE(

    [Sales USD],

    FILTER (

        ALL ( 'TY Group'[Country],'TY Group' [Calendar Day] ),

        'TY Group'[Country]="USA" || 'TY Group'[Calendar Day]  = TODAY()-1))

But only the first (Country) filter worked and had the sum of sales for the all period.

Could anyone help me with this?

Thanks in advance.

[Greg_Deckler · Accepted solution]

@Julia_Mav Maybe:

For yesterday =

CALCULATE(

    [Sales USD],

    FILTER (

        ALL ( 'TY Group'[Country],'TY Group' [Calendar Day] ),

        'TY Group'[Country]="USA" && 'TY Group'[Calendar Day]  = TODAY()-1))

However, if you are using a single table data model, you may be running into issues with CALCULATE. What is the formula for your [Sales USD] measure?

[Anonymous · Accepted solution]

Hi Julia_Mav

I guess, I would try to use && instead of ||. At the moment your DAX formula is just considering one of the two criterias.

[Julia_Mav]

Thank you @Anonymous, it's working now! 

[Greg_Deckler · Accepted solution]

@Julia_Mav Maybe:

For yesterday =

CALCULATE(

    [Sales USD],

    FILTER (

        ALL ( 'TY Group'[Country],'TY Group' [Calendar Day] ),

        'TY Group'[Country]="USA" && 'TY Group'[Calendar Day]  = TODAY()-1))

However, if you are using a single table data model, you may be running into issues with CALCULATE. What is the formula for your [Sales USD] measure?

[Julia_Mav]

Thank you @Greg_Deckler!!! It works now.