Filter from an independent table value

[sxuanjing]

Hi Hi

I would like to get some advice on should I approach this scenarios if possible

Table A with Column "DayLeft"

Table B 

These 2 tables are not related

I wanted 

1) create a slicer with TableB [Expire] Column

2) when i choose 3 Months

3) TableA will only display DayLeft >= 90

Thank you 

[sxuanjing]

Hi @sanalytics 

Thank you so much for your time to prepare the solution. 😀

I really appreciate it. 

[sanalytics · Accepted solution]

Hello @sxuanjing 

Try to Create a measure which will help you acheive this

Something like below

Tag = IF(
MAX( TableA[DayLeft] ) >= SELECTEDVALUE(TableB[value]),
1,0
)

Attached is the screenshot and Power Bi file

https://dropfiles.org/EG888s

Have a look

Regards

sanalytics

if it is your solution then please like and accept it as your solution