Forum Discussion

Julia_Mav's avatar
Julia_Mav
Icon for Helper II rankHelper II
3 years ago
Solved

Calculate and two filters

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 Grou...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

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's avatar
Julia_Mav
Icon for Helper II rankHelper II
3 years ago

Thank you Greg_Deckler!!! It works now.