How can I have my running total be filtered by a slicer?

[mds123]

The below dax function returns a running total for the sales table I use. I'm able to filter the value by a customer table, but not by the date table I use. My date table has a custom column called Periodnum( values 1–12), and each period is roughly 28 days, but not always.

When I filter by the period, the date in my table updates, but the measure does not update as intended. It shows the total running time since the beginning of my dataset. I think the issue has to do with my variable LastDateWithSales. I replaced the calculate with just the max date, but that does not filter the measure either. My goal is that if I filter to Period 2, the counter starts at 0, and then day 1 would have the sales from day 1, day 2 would have the sales from days 1 and 2, etc.

Running Invoice =

var selectedPeriod = [selected period]

var LastVisibleDate = MAX(Dates[Date])

var FirstVisibleDate = min(Dates[Date])

VAR LastDateWithSales =

    CALCULATE (

        MAX ( 'Invoices'[Invoice Date]),

        REMOVEFILTERS()    -- Use ALL ( Sales ) if REMOVEFILTERS () and ALL ()

                           -- are not available

    )

 VAR Result =

    IF (

        FirstVisibleDate <= LastDateWithSales,

        CALCULATE (

            SUM('Invoices'[Total Gross Sales]),

            'Dates'[Date] <= LastVisibleDate

                )

    )    

RETURN Result

[mds123 · Accepted solution]

Solved it! I wasn't including the fiscal year and period in the result variable. Below is the updated code if it helps anyone else out.

Running Invoice 2 =

var selectedPeriod = [selected period]

var selectedYear = [selected fiscal year]

var LastVisibleDate = CALCULATE(MAX(Dates[Date]))

var FirstVisibleDate = min(Dates[Date])

VAR LastDateWithSales =

 MAX ( 'Invoices'[Invoice Date])

 VAR Result =

    IF (

        FirstVisibleDate <= LastDateWithSales,

        CALCULATE (

            SUM('Invoices'[Total Gross Sales]),

            'Dates'[Date] <= LastVisibleDate,

            'Dates'[PeriodNum] = selectedPeriod,

            Dates[FY] = selectedYear

                )

    )    

RETURN Result