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

Anonymous's avatar
Anonymous
Not applicable
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