Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter three values according to three different dates

Hello,   Is it possible to get sum of three measures where the three measures are affected by three different date ranges? I need Data = Measure1 + Measure2 + Measure3 Measure1 is affected by dat...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Right, sample data explains everything. So what you want is:

     

    I need Data = 
CALCULATE([Measure1],ALLEXCEPT('Table'[Date1])) + 
  CALCULATE([Measure2],ALLEXCEPT('Table'[Date2])) + 
    CALCULATE([Measure3],ALLEXCEPT('Table'[Date3]))

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Greg_Deckler 

Sum CompletedDate 1Date2Date3
101/02/2020  
202/02/2020  
303/02/202005/02/2020 
404/02/202006/02/2020 
505/02/202007/02/2020 
606/02/202008/02/2020 
707/02/202009/02/2020 
808/02/202010/02/202010/02/2020
909/02/202011/02/202011/02/2020
1010/02/202012/02/202012/02/2020
1111/02/202013/02/202013/02/2020
1212/02/202014/02/202014/02/2020
1313/02/202015/02/202015/02/2020
1414/02/202016/02/202016/02/2020

 

Measure1, measure2 and measure3 are going to be sum of sum completed. If we adjust date slicer date1 from 01/02/2020 to 04/02/2020, date2 from 05/02/2020 to 09/02/2020 and date3 from 10/02/2020 to 16/02/2020 for measure1, measure2 and measure3 respectively, I want the sum of the measures to be for measure1 with date1 range, measure2 with date2 range and measure3 with date3 range.

 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Right, sample data explains everything. So what you want is:

 

I need Data = 
CALCULATE([Measure1],ALLEXCEPT('Table'[Date1])) + 
  CALCULATE([Measure2],ALLEXCEPT('Table'[Date2])) + 
    CALCULATE([Measure3],ALLEXCEPT('Table'[Date3]))