Forum Discussion

sxuanjing's avatar
sxuanjing
Frequent Visitor
4 years ago
Solved

Filter from an independent table value

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 

Need Help
  • sanalytics's avatar
    sanalytics
    4 years ago

    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

     

     

2 Replies

  • sanalytics's avatar
    sanalytics
    Icon for Super User rankSuper User
    4 years ago

    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

     

     

  • sxuanjing's avatar
    sxuanjing
    Frequent Visitor
    4 years ago

    Hi sanalytics 

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

    I really appreciate it.