Forum Discussion
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 date range A, Measure2 is affected by date range B and Measure3 is affected by date range C.
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]))
5 Replies
- Greg_Deckler
Community Champion
Really, really hard to tell. Would need to see the formulas of the measures. Sample data would b great. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Sum Completed Date 1 Date2 Date3 1 01/02/2020 2 02/02/2020 3 03/02/2020 05/02/2020 4 04/02/2020 06/02/2020 5 05/02/2020 07/02/2020 6 06/02/2020 08/02/2020 7 07/02/2020 09/02/2020 8 08/02/2020 10/02/2020 10/02/2020 9 09/02/2020 11/02/2020 11/02/2020 10 10/02/2020 12/02/2020 12/02/2020 11 11/02/2020 13/02/2020 13/02/2020 12 12/02/2020 14/02/2020 14/02/2020 13 13/02/2020 15/02/2020 15/02/2020 14 14/02/2020 16/02/2020 16/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
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]))
- parry2k
Super User
Anonymous not sure how your data model looks like, if you already correctly calculated your base 3 measure then new measure can be just sum of these three, something like this
New measure = [Measure 1] + [Measure 2] + [Measure 3]Would appreciate Kudos 🙂 if my solution helped.
Sum Completed Date 1 Date2 Date3 1 01/02/2020 2 02/02/2020 3 03/02/2020 05/02/2020 4 04/02/2020 06/02/2020 5 05/02/2020 07/02/2020 6 06/02/2020 08/02/2020 7 07/02/2020 09/02/2020 8 08/02/2020 10/02/2020 10/02/2020 9 09/02/2020 11/02/2020 11/02/2020 10 10/02/2020 12/02/2020 12/02/2020 11 11/02/2020 13/02/2020 13/02/2020 12 12/02/2020 14/02/2020 14/02/2020 13 13/02/2020 15/02/2020 15/02/2020 14 14/02/2020 16/02/2020 16/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.
