Help writing a Measure that calculates MTD AND filter by another field

[Midway]

I have a measure that I need to build that needs to do the following;

Calculate the MTD of Sales and then filter it down by another field Sales status = "Active"

I think the CALCAULATE function can be use here like this;

CALCULATE(SUM(Sales[SalesAmount]), DATESMTD(DimDate[Date])) AND then here I need to filter by another field, SaleStatus.

SalesStatus has two values "Active" and "Cancelled", I need to retrieve rows with SalesStatus = "Active".

Thanks very much for you help!

[Midway]

Thank you!

[tamerj1 · Accepted solution]

Hi @Midway 

Please try

=
CALCULATE (
    SUM ( Sales[SalesAmount] ),
    DATESMTD ( DimDate[Date] ),
    Sales[SaleStatus] = "Active"
)