topic Re: Help writing a Measure that calculates MTD AND filter by another field in DAX Commands and Tips

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

Midway — Sat, 15 Oct 2022 15:58:34 GMT

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!

tamerj1 — Sat, 15 Oct 2022 16:27:18 GMT

Please try

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

Midway — Sun, 16 Oct 2022 22:25:55 GMT

Thank you!