Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rschaudhr
Resolver II
Resolver II

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
jdbuchanan71
Super User
Super User

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
    )

View solution in original post

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

View solution in original post

5 REPLIES 5
jdbuchanan71
Super User
Super User

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
    )

Unfortunately, this did not work

@rschaudhr 

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?

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

kentyler
Solution Sage
Solution Sage

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





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.