Forum Discussion
Solved
Filter 2nd Table (Visual) based on 1st Table (Visual)
Hi, I have been stuck on the following problem for a few days. I have 2 tables on a page, the data comes from the same imported DB Table (Sheet1): Table 1 Table 2 I need to ...
Hi Shaundekok ,
Based on your description, you can create a measure as follows.
Measure =
var x1=SELECTEDVALUE('Table1'[Date])
var X2=SELECTEDVALUE(Table1[Location])
return
IF(MAX('Table2'[Date])=x1&&MAX('Table2'[Location])=X2,1,0)Result:Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Shaundekok ,
Based on your description, you can create a measure as follows.
Measure =
var x1=SELECTEDVALUE('Table1'[Date])
var X2=SELECTEDVALUE(Table1[Location])
return
IF(MAX('Table2'[Date])=x1&&MAX('Table2'[Location])=X2,1,0)
Result:
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.