cancel
Showing results for
Did you mean:
Frequent Visitor

## Create a measure based on date filter slicer

I have a dashboard with Table visualization and has a date filter. I want to create a calcutate measure based on the end date of the date slicer.

So, if my date range in date slicer is from 7/25/2019 to 8/19/2019, then the measure should only take value from 8/19/2019. Further more, I have a measure already and would like to incorporate it in the measure if possible. The measure is as follows:

Calculate = divide(sum([EOP MV]), CALCULATE(SUM([EOP MV]),ALLEXCEPT(IPA,Date,[Manager])))

I hope this is enough information.

Thank you,
RC

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User IV

## Re: Create a measure based on date filter slicer

Hello @rschaudhr

Give this a try.

```Measure =
VAR _LastDate =
LASTDATE ( Dates[Date] )
RETURN
CALCULATE (
DIVIDE (
SUM ( [EOP MV] ),
CALCULATE ( SUM ( [EOP MV] ), ALLEXCEPT ( IPA, Date, [Manager] ) )
),
_LastDate
)
```
Frequent Visitor

## Re: Create a measure based on date filter slicer

Actually, I am misspoken. Your solution did work. Thank you for this.

5 REPLIES 5
Super User II

## Re: Create a measure based on date filter slicer

Here is a post about creating the measure that references a date range slicer

https://community.powerbi.com/t5/Desktop/Filter-data-using-date-range-from-slicer/td-p/483072

Super User IV

## Re: Create a measure based on date filter slicer

Hello @rschaudhr

Give this a try.

```Measure =
VAR _LastDate =
LASTDATE ( Dates[Date] )
RETURN
CALCULATE (
DIVIDE (
SUM ( [EOP MV] ),
CALCULATE ( SUM ( [EOP MV] ), ALLEXCEPT ( IPA, Date, [Manager] ) )
),
_LastDate
)
```
Frequent Visitor

## Re: Create a measure based on date filter slicer

Unfortunately, this did not work

Super User IV

## Re: Create a measure based on date filter slicer

You will have to give a bit more information.  Did you receive an error or an unexpected result?  Can you share some of your sample data in a format that can be copied (not a screen shot) and show us how your model is layed out and what the expected result is?

Frequent Visitor

## Re: Create a measure based on date filter slicer

Actually, I am misspoken. Your solution did work. Thank you for this.

Announcements

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

#### Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors