Dax function datesbetween

[Jeffrey_VC]

Hi,

I'm trying to build a measure to calculate records.
In this measure I'm using the function Datesbetween.
It looks that that function working but when I add a slicer to this data the data will be the same.

What I'm doing wrong?

Records user = CALCULATE(

    COUNTROWS('Query1'),

    DATESBETWEEN(Datetable[date], MIN(vc_lot_lotuser[Start Date]), MAX(vc_lot_lotuser[End Date])),

    USERELATIONSHIP(vc_lotuser[Lot User], Query1[LotId]))

Thnx!

[FreemanZ]

hi @Jeffrey_VC 

which column do you have for the slicer?

If it is date-relevant column, ensure to take the columns from the datetable.

[Jeffrey_VC]

Hi @FreemanZ 

I'm using de Datetable[date] in my slicer.

[FreemanZ]

hi @Jeffrey_VC 

how are the three tables related?

[Jeffrey_VC]

This is the model:

[Jeffrey_VC]

@FreemanZ 

this is the model:

[FreemanZ]

hi @Jeffrey_VC 

what column do you have for the mentioned slicer?

[Jeffrey_VC]

Hi @FreemanZ ,

I'm using the column "date" from the table datetable