Forum Discussion
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])))
- Anonymous1 year ago
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.
1 Reply
- AnonymousNot 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.