MTD measure and Date Filters
All, Please i have a MTD measure that works fine. I have included this measure in a table visualization. i have a date slicer on my report page. I want the MTD measure figures to remain unchanged if i apply the date filter. example if my date slicer is for 1st - 18th June, MTD should display values for June 1st to June 28th. Can this be done, or i am missing something. Below are my snips. MTD measure = MTD2 = Calculate([MeasureName],DATESMTD(CalendarTable[Date])) Thanks for your hepl. really appreciate.
