Measure showing blanks when changing context from days to months

[DSiffredi]

Hi there, I hope someone can help here...

Scheduled Sales =
VAR Last Billable Date = CALCULATE(MAX(Sales[Date]) ,ALL(Sales))
RETURN
IF(SELECTEDVALUE(Date[Date]) <Last Billable Date , BLANK(),
CALCULATE([Future Sales]))

the DAX statement above intends to aggregate future sales when the day is bigger than the last day we have a sale registered. Calculate function on future sales works like a charm.

This DAX statement indeed works well if the context is days , but shows nothing if the context changes from days to months. What am I doing wrong that everything looks fine and works with the context of days but nothing if the context are months?

I'd expect to have the aggregation of days in a month and show that as a results instead of blanks.

thanks for your time
Daniel

[v-chuncz-msft · Accepted solution]

@DSiffredi,

SELECTEDVALUE returns the value when there’s only one value in the specified column, otherwise returns the alternate result. Here BLANK is returned. You may use MAX instead.

[v-chuncz-msft · Accepted solution]

@DSiffredi,

SELECTEDVALUE returns the value when there’s only one value in the specified column, otherwise returns the alternate result. Here BLANK is returned. You may use MAX instead.

[DSiffredi · Accepted solution]

that worked like a charm . Thank you so much for taking the time to help me with this!

[DSiffredi]

BTW: Here's a couple of screenshots showing what I meant 

as you can see it shows Scheduled Sales when slicing by daysNot showing any values or agregations when slicing by Months (FYFM in this case)