Filter table with calendar date not related

[jmarciogsousa]

Hi,

I would like sign if one id contains valid contract with base on date slicer.
I got it working when has the dates context on the table, but when I remove the dates from the table it returns one value that I don't expect:

I would like that this table returns FielterDateGueltig = 1 for P625 and P626:

Thank you for your attention.

All the best,
Joao

[v-rzhou-msft · Accepted solution]

Hi @jmarciogsousa ,

According to your statement, I think you need a summarize result. I suggest you to try ALLSELECTED() function in your measure.

My Sample:

Measure:

FilterDateGueltig = 

VAR _T1 = 
FILTER(ALLSELECTED(BefoerderungsplanGueltig),
AND(
    OR([gueltig_von]<[MinDateSlicer],[gueltig_von] < [MaxDateSlicer]),
    OR([gueltig_bis]> [MinDateSlicer],[gueltig_bis]>[MaxDateSlicer]))
)
RETURN
COUNTAX(FILTER(_T1,[Befplannummer] = MAX(BefoerderungsplanGueltig[Befplannummer]) && [Wagenfahrten] = MAX(BefoerderungsplanGueltig[Wagenfahrten])),[Befplannummer])

Result is as below.

Best Regards,
Rico Zhou

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