How to compare two tables to filter data

[Anonymous]

Hi,

I have one table with 3 years of monthly sales that includes products numbers and an additional table with about 500 products numbers I want to pull sales totals for.  How do I get it to filter on that table? I've added it as to 'Filters on this page only', all of the products numbers are selected, but my visual is still showing all records in the original file.  I'm sure it's a simple thing to do, but being so new to Power bi, I was hoping someone could walk me through it.

Thanks!!!

[amitchandak]

@Anonymous , is the product table(assumed have a unique product and used in slicer) is joined properly. If join is missing or inactive it can happen

If the interaction has been turned off this can happen

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

If all has been used in table formula it can happen

calculate([measure],all(Table))

[parry2k]

@Anonymous share sample data and what you are trying to achieve, also share the screenshots. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 

[Anonymous]

The link you provided is no longer valid.  I only want the visual to show the product numbers that are the on Q4 Prod nums list that are included the 2017 file in the List Number field. 2017 would be my main file and Q4 Prod nums my secondary file.  In essence a vlookup to determine the sales for certain product numbers during a partical year. Screenshots are attached.

[Greg_Deckler]

@Anonymous Do you have a relationship between your two tables?

If not, you can also accomplish this using the IN operator.

[Anonymous]

Hi Greg!

I don't have a relationship set up between the two tables.  How would I do that?

Thanks for helping the newbie!

_stephanie 

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ，

You can add a filter in your formula ：

'Table'[List Number]  IN VALUES('Table2'[Nums Q4])

Best Regards,

Dedmon Dai