Dax measure filtering in charts

[strn1k]

Hi I have an issue with filtering my charts by DAX measure.

This is my measure: 

IsInDateRange =

VAR FromDate = MIN(DateTable[Date])

VAR ToDate = MAX(DateTable[Date])

RETURN

IF (

        SELECTEDVALUE(DataSource[JADate]) >= FromDate

        && SELECTEDVALUE(DataSource[JADate]) <= ToDate

        && SELECTEDVALUE(DataSource[DateSigned]) <= ToDate

        && SELECTEDVALUE(DataSource[CvOutDate]) <= ToDate

        && SELECTEDVALUE(DataSource[SendOutDate]) <= ToDate

        && SELECTEDVALUE(DataSource[ScoreDate]) <= ToDate

        && SELECTEDVALUE(DataSource[DateInterview]) <= ToDate

        && SELECTEDVALUE(DataSource[InterviewsScoreDate]) <= ToDate,

    1,

    0

)

I use its result as a filter (IsInDateRange is 1) in my table visualization and it works as it should. 
But when I put this measure as a filter into my graphs and pie chart it doesnt work.

For example when I select date range 1.1.2024 - 7.1.2024 there are 1199 rows (JobApplication Ids) in my table but in my stacked bar chart where I want to split JobApplications by "Collar" I can see the total counts without any restriction (filter) and thats also correct but when I apply the IsInDateRange measure into the filters on this visualization all the data is gone...

I tried many things to fix this but I am out of ideas.

Thank you in advance for any advice

Below I attached some screenshots which should be helpful to understand the problem.

[Anonymous]

Hi @strn1k ,

May I ask if your problem has been solved. If the above reply was helpful, you may consider marking it as solution. If the problem is not yet solved, please feel free to ask us a question.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

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

[strn1k]

Hi, no the problem has not been solved. @lbendlin just gave me prettier code.

[lbendlin]

Consider simplifying your code.

IsInDateRange =
IF (
        SELECTEDVALUE(DataSource[JADate]) IN DateTable[Date]
        && MAX(SELECTEDVALUE(DataSource[JADate]),
               SELECTEDVALUE(DataSource[DateSigned]),
               SELECTEDVALUE(DataSource[CvOutDate]),
               SELECTEDVALUE(DataSource[SendOutDate]),
               SELECTEDVALUE(DataSource[ScoreDate]),
               SELECTEDVALUE(DataSource[DateInterview]),
               SELECTEDVALUE(DataSource[InterviewsScoreDate])) <= MAX(DateTable[Date]),
    1,
    0
)

Is your calendar table disconnected?

[strn1k]

Thanks for the prettier code. 

Yes, the calendar table is not linked to the DataSource table as you can see in the screenshots I provided.