Forum Discussion

itsranga's avatar
itsranga
Helper I
1 year ago
Solved

DAX filter condition not working

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 

 

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.