Link matrix or table to date slicer

[frankhofmans]

hi all,

i have the following table or matrix i want to present:

Case ID	Start Date	End date	Name
001	01-01-2020	10-02-2020	Mike
002	10-01-2020	13-02-2020	Lisa
003	15-01-2020	15-02-2020	John
004	16-01-2020	16-02-2020	Frank
005	20-01-2020	20-02-2020	Sarah
006	30-01-2020	01-03-2020	George

I have added a indirect relation between start-date and my date table. When i want to add a date slicer (for example week number) the matrix or table doesn't change when i select fe only week 1 and 2 (case id 004, 005, 006 are still in the matrix). Any ideas how to link this kind of table or matrix with a date slicer?

thanks in advance!

Regards,

Frank

[Pragati11]

Hi @frankhofmans ,

Can you please share screesnhot of your data model here with relationships that you have created?

Thanks,

Pragati

[frankhofmans]

hi Pragati,

i think i solved it. i used the following measure: Is in range = VAR r = CALCULATE( COUNTROWS(Data), USERELATIONSHIP( Date,start_date ) ) RETURN IF(ISBLANK(r), 0, r)

thanks for the quick response,

Regards,

Frank