Forum Discussion
bendejnp
Helper I
Helper IUsing active and inactive in one measure
Hello, Below is a simplified example of the dataset showing the orders with an order date and a date for requisted delivery. Example data: order date and requested delivery date ar...
OK, try
Turnover MTD = var mtd = DATESMTD( 'Calendar'[Date]) return CALCULATE( SUM('Table'[Turnover]), REMOVEFILTERS('Calendar'), TREATAS( mtd, 'Table'[Order date]), TREATAS( mtd, 'Table'[Delivery date]) )You may need to alter the REMOVEFILTERS if the order day & month aren't coming from the Calendar table.
bendejnpHelper I
Helper ISorry my last post was not regarding DAX studio. I was typing whilst you already answered. I don't have DAX studio and cannot install on my business laptop.
However I found out the formula shows only the lines order date of the selected calendar day. Example:
The measure shows 435€, but it should shows 1690.
johnt75
Super User
Super UserOK, try
Turnover MTD =
var mtd = DATESMTD( 'Calendar'[Date])
return CALCULATE( SUM('Table'[Turnover]),
REMOVEFILTERS('Calendar'),
TREATAS( mtd, 'Table'[Order date]),
TREATAS( mtd, 'Table'[Delivery date])
)You may need to alter the REMOVEFILTERS if the order day & month aren't coming from the Calendar table.
- bendejnp
With the suggested change it works now. Thank you!
However, I didn't understand which the "removefilter" has and why I have to use it here 😄