cancel
Showing results for
Did you mean:
Highlighted
Helper III

## 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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV

## Re: Filter three values according to three different dates

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

---------------------------------------

Putting square pegs in round holes since 1972.

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Datanaut!

5 REPLIES 5
Super User IV

## Re: Filter three values according to three different dates

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

---------------------------------------

Putting square pegs in round holes since 1972.

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Datanaut!

Super User IV

## Re: Filter three values according to three different dates

@cfpvin 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.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helper III

## Re: Filter three values according to three different dates

 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.

Helper III

## Re: Filter three values according to three different dates

 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.

Super User IV

## Re: Filter three values according to three different dates

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

---------------------------------------

Putting square pegs in round holes since 1972.

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Datanaut!

Announcements

#### Announcing the New Spanish Forum

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

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

#### ‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors