SELECTEDVALUE AS FILTER

[Anonymous]

Good afternoon everyone,

I have a table named (main) with two columns(date1 and date2), we could say date1 is the starting date and date2 is the finishing one.

Also, I have a date table I have created to connect the data from the main table to this one.

The purpose of my question is the next: 

I want to create a date filter where I can range the dates and count the rows from the main table which have the dates (date1 and date2) between the dates I have selected. Up to this point, everything is right I'm obtaining the results I'm looking for.

But everything change when I want to count the rows from the main table whose date1 dates are < date selected in the filter..

I have tried the following DAX: 

RESULTS < =

VAR SELECTEDM = SELECTEDVALUE('CALENDAR'[Date])

RETURN

COUNTROWS(FILTER('MAIN';'MAIN'[DATE1]<SELECTEDM))

DAX  function is working but it's not throwing back the correct result 

Any help?

Kind Regards,

Adrian

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You could try the following DAX:

RESULTS < =
VAR SELECTEDM =
    MINX ( ALLSELECTED ( 'CALENDAR'[Date] ); 'CALENDAR'[Date] )
RETURN
    COUNTROWS ( FILTER ( 'MAIN'; 'MAIN'[DATE1] < SELECTEDM ) )