Count Rows Between Two Date Columns

[comerlatto_tcr]

Hello!
Need help with a measure to count the number of rows that falls between the selected dates on a slicer. My table has a column with start date and another with end date:

and they have a relationship with a calendar table (where I get the slicer from):

this is what I've got so far:
Measure =
VAR _inicio_data = FIRSTDATE(calendario[Date])
VAR _fim_data = LASTDATE(calendario[Date])
VAR _calc=
CALCULATE(COUNTROWS(pipedrive), FILTER(pipedrive, pipedrive[data_fim_calculos] >= _inicio_data && pipedrive[data_fim_calculos] <= _fim_data))
RETURN
IF(ISBLANK(_calc), 0, _calc)

but since I'm using only the active relationship ïm not getting the result I need.

Hope somebody can help me out!
Thanks.

[Anonymous · Accepted solution]

Hi @comerlatto_tcr ,

Below is my test table and data model:

Table:

 

Date:

Measure =
VAR min_date =
    MIN ( 'Date'[Date] )
VAR max_date =
    MAX ( 'Date'[Date] )
VAR tmp =
    FILTER ( 'Table', [Start Date] >= min_date && [End Date] <= max_date )
RETURN
    COUNTROWS ( tmp )

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.