DAX filter condition not working

[itsranga]

Hi,

i have 2 table in Power bi 

Actual Data

if i click table 1 any row created date based i need to filter second table schedule start date 

example (if click first table first row means created date is 01/20/2025 ,  second table schedule date need to filter 01/20/2025 to 01/14/2025)  scheduled between 20th to 14th data required)  i Used Measure

Measure = 
SWITCH(TRUE(),
SELECTEDVALUE(Table1[CreatedDate])=BLANK(),1,
SELECTEDVALUE(Table2[Schedule date])<=SELECTEDVALUE(Table1[CreatedDate])
  &&SELECTEDVALUE(Table2[Schedule date])>=SELECTEDVALUE(Table1[CreatedDate])-6,1,
0)

after filter i need no of ticket count Need

I attached sample file

im using this DAX but its retun blank value

Measure 2 = CALCULATE(COUNTROWS(Table2),FILTER(Table2,SELECTEDVALUE(Table1[CreatedDate])<=SELECTEDVALUE(Table2[Schedule date]) &&SELECTEDVALUE(Table1[CreatedDate])>=SELECTEDVALUE(Table2[Schedule date])))

Download PBIX file 

[Anonymous · Accepted solution]

Hi @itsranga 

Please try this:

No of ID =
COUNTROWS ( FILTER ( 'Table2', 'Table1'[Measure] = 1 ) )

The result is as follow:

Best Regards

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