Fiscal Month Running Total

[joshua1990]

I would like to get the running total for the selected fiscal month on a daily level.

This is the measure I have built so far:

Running Total = 
VAR RunningTotal =
    CALCULATE (
        [Sales],
        FILTER (
            ALL ( 'Fiscal Calendar' ),
            'Fiscal Calendar'[Fiscal Year] = VALUES ( 'Fiscal Calendar'[Fiscal Year] )
                && 'Fiscal Calendar'[Fiscal Month Num] = VALUES ( 'Fiscal Calendar'[Fiscal Month Num] )
                && 'Fiscal Calendar'[Date] <= TODAY()
        )
    )
RETURN
    RunningTotal

Unfortunately, this measures shows me in a matrix with dates as rows the running total for every day. 

Date	Sales	Running Total
02.08.2021	150000	150000
03.08.2021	0	150000
04.08.2021	0	150000

Why is that so? I have a filter on "TODAY". What have I missed?

[Anonymous]

Try using ALLSELECTED instead of ALL.  

[joshua1990]

Nope, that makes no changes