Forum Discussion

ephramz's avatar
ephramz
Icon for Helper II rankHelper II
5 years ago
Solved

Filter pane function

I have two tables. Table 1 with all the raw data imported from SQL database Table 2 with all my own data imported from excel   Table 1 and Table 2 both have  two column namely (Strategy) and (Pac...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi ephramz ,

     

    You could create a measure like below.

    measure = IF(selectedvalue(table1[strategy]) in values(table2[strategy])&&selectedvalue(table1[package]) in values(table2[package]),1,0)

    Then add this measure to visual filter and filter measure =1. This will filter the records in table1 have both strategy and package in table2.

    You could change the && symbol in the formula to || symbol. This will filter the records in table1 have strategy or package in table2.

    If I misunderstand your requirement, please show some sample data and expected result to us.

     

    Best Regards,

    Jay

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
5 years ago

Hi ephramz 

 

Is there any relationship between those 2 tables?

you can use LOOKUPVALUE dax code to create a new column in Table 1.

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!