Cumulative Total to specific date

[mdgene]

Please I have a measure that shows the cumulative measure upto specific date. But My measure still show values past the date expected. I have added a screen shot of the result below. 

If I use date in place of Month it works, but I will like to see it at month level. (screen shot attached). Please what is your advice

This is my dax measure

Cummulative Sold max  =

VAR LastSaleDate = CALCULATE(LASTDATE('Forecast Revenue'[Closed Date]),'Forecast Revenue'[Forecast Category] = "sold")

RETURN

IF(SELECTEDVALUE('Date Table'[Date]) >[LastSaleDate] ,

BLANK(),

CALCULATE( 'Key Measures'[Sold],

FILTER(ALLSELECTED('Date Table'),

'Date Table'[Date] <= MAX('Date Table'[Date]) ) ))

[V-lianl-msft]

Hi @mdgene ,

Has the problem been solved? If the problem persists, please delete the sensitive data and provide a sample pbix so that i can do more tests.https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-... 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mdgene]

I am still on it. I will modify and send over. Thank you

[amitchandak]

@mdgene , Try like

Cummulative Sold max =
VAR LastSaleDate = CALCULATE(LASTDATE('Forecast Revenue'[Closed Date]),filter(allselected('Forecast Revenue'),'Forecast Revenue'[Forecast Category] = "sold"))
RETURN
CALCULATE( 'Key Measures'[Sold],
FILTER(ALLSELECTED('Date Table'),
'Date Table'[Date] <= MAX('Date Table'[Date]) && SELECTEDVALUE('Date Table'[Date]) >[LastSaleDate] ))

I doubt you are using month from date table in first visual

or

Cummulative Sold max =
VAR LastSaleDate = CALCULATE(LASTDATE('Forecast Revenue'[Closed Date]),filter(allselected('Forecast Revenue'),'Forecast Revenue'[Forecast Category] = "sold"))
RETURN
CALCULATE( 'Key Measures'[Sold],
FILTER(ALLSELECTED('Date Table'),
'Date Table'[Date] <= MAX('Date Table'[Date]) && SELECTEDVALUE('Date Table'[Date]) < [LastSaleDate] ))

[mdgene]

Hi , I tested the two query, query 1, was returning blank. while query 2 was behaving just like my query. also I am using the date column. Thank you