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
ScottR-MT
Helper I
Helper I

Need to Alter DAX Running Total Quick Measure to Ignore Date Filter

Hi,

 

I created a Running Total Quick Measure by Month, which I am filtering to only the last 6 months.  When filtered, the totals begin with the total from the first month displayed, and not from the beginning.  I would like for the total on the first month start with the total from the beginning of time, and not from that month.  Is this possible?  Below is the formula from the Quick Measure and a screen shot of the table.

 

IB =
CALCULATE(
    DISTINCTCOUNT('Install Base'[SerialNo]),
    FILTER(
        CALCULATETABLE(
            SUMMARIZE('Calendar', 'Calendar'[Month No], 'Calendar'[Month-Year]),
            ALLSELECTED('Calendar')
        ),
        ISONORAFTER(
            'Calendar'[Month No], MAX('Calendar'[Month No]), DESC,
            'Calendar'[Month-Year], MAX('Calendar'[Month-Year]), DESC
        )
    )
)
 
In this table, the totals should be much higher.  
If I remove the date filter, they go back to the correct amounts. 
PBI Table.png
1 ACCEPTED SOLUTION

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

10 REPLIES 10

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.