Hiding future dates with no values when using drill down

[Anonymous]

Hello Community  -  I am using the measure below for YTD which I like because it hides future dates that have no values when putting in a column chart.   Like below.  

The problem comes when I try to drill down to the month level  (from the "date" level).   At the Date level, the visual displays as it should.   But at the month level, it does not hide future dates...it just repeats the current YTD value for each of the future months as you see in the 2nd visual. 

Any way to modify this formula so the month level view also hides the future months?

Cumulative Orders 2 =

VAR LastOrderDate = CALCULATE(LASTDATE('Orders 2'[Order Date]),ALL('Orders 2'))

RETURN

IF(SELECTEDVALUE('Date Table'[Date]) > LastOrderDate, BLANK(),

CALCULATE([YTD Sum of Orders 2],FILTER(ALLSELECTED('Date Table'),'Date Table'[Date] <= MAX('Date Table'[Date]))))

view based on the Date value on the x axis  from my date table

Does not hide future months if I drill down to Month (from my date table)

[negi007 · Accepted solution]

@Anonymous there is a workaround for it

in your date table, create one more custom column like below

is before today = IF(sle[Date]<=TODAY(),TRUE(),FALSE())

then you can use this new column as a filter, in your chart. all dates before today will always be true.

for more details, please refer to below blog

https://blog.enterprisedna.co/show-results-up-to-current-date-or-a-specific-date-in-power-bi/

[amitchandak]

@Anonymous , Try like

Cumulative Orders 2 =
VAR LastOrderDate = maxx(allselected('Orders 2'),'Orders 2'[Order Date])

RETURN
IF(max('Date Table'[Date]) > LastOrderDate, BLANK(),
CALCULATE([YTD Sum of Orders 2],FILTER(ALLSELECTED('Date Table'),'Date Table'[Date] <= MAX('Date Table'[Date]))))

[Anonymous]

@amitchandak 
That basically worked except for when I drill down from Date to Month...it only shows the month of January...and should be showing Jan and Feb.    When I drill down from the month, it properly shows the weeks.   But it's odd that the Feb month is missing when I drill to the Month level?