measure with a false/true filter doesn't work

[Anika3186]

Hello,
I want to create a YTD filter. This filter should be based on a measure (Highest Date = Max('Sales'[Date])

The YTD filter should therefore display "true" if the date from my sales file is less than or equal to the date from the measure.

I had created the following Dax formula as a calculated column:

YTD = IF (

(Datetable[Date])<=(Sales[Highest Date]),

TRUE (),

FALSE ()

)

Unfortunately, I only get "false" returned. What am I doing wrong? Can anyone help?

Many Thanks.

Anika

[ValtteriN · Accepted solution]

Hi,

It is likely your Sales[Highest Date]  is returning BLANK in the column filter context. This happens e.g. for every date without sales if you have a relationship between the tables. To solve this you can use funtions like ALL or CROSSFILTER. e.g.

So a possible fix:

YTD = IF (

(Datetable[Date])<=CALCULATE(Sales[Highest Date]),ALL(Sales)),

TRUE (),

FALSE ()

)

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/