Total Month to Date for ONLY Saturdays within that month

[Adam01]

Hello,

I have a table that looks like the below:

I want to create a measure that has a running total of [Amount] made on a Saturday Only, so [Day of Week] = 6. I've tried the following:

CALCULATE (

    TOTALMTD ( [Amount], 'Calendar'[Date] ),

    FILTER (

        'Calendar',

        'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) &&

        CONTAINSSTRING (

            VALUES ( 'Calendar'[DayLongName] ),

            "Saturday"

        )

    )

)

I've also tried something more simple:

CALCULATE (

    TOTALMTD ( [Amount], 'Calendar'[Date] ),

    'Calendar'[DayOfWeekValue] = 6

)

However the issue I keep running into is that values ARE being displayed for a saturday but it is a running total of the days leading up to the saturday, for example on this table for the first saturday on the month it would be Thursday + Friday + Saturday:

Any help would be much appreciated

[Adam01 · Accepted solution]

Never mind! I've just figured out that the TOTALMTD has an optional Filter at the end of the function that allows to filter to specific [Day of Week] values:

TOTALMTD (
    [Amount],
    'Calendar'[Date],
    'Calendar'[DayOfWeekValue] = 6
)