How to apply filters from one report to another

[amustafa70]

Hello Everyone, I'm new to PowerBI and looking for your help. I have set of seller_names who sold specific products (pct). What I need is to create a list of seller_name as competitors who sold same products minus the original seller_name. I don't know how to set custom filters. Please see the attached .pbix file. 

pbix file download link: https://drive.google.com/file/d/1wCDMhmK6mSkgDnemzQLscNsFQFIsjHaL/view?usp=sharing

[mahoneypat]

To do that, you need to make a disconnected table with your seller names and use that new seller name column in your slicer.  There is no relationship between this new table and your existing table.  You can then make a table visual with the seller name column from your query1/original table and add this measure.  Only those sellers that sold the same as the selected seller (and products) should show.

Sellers = DISTINCT(Query1[seller_name])

Sold Same Product =
VAR vProducts =
    CALCULATETABLE (
        VALUES ( Query1[pct] ),
        Query1[seller_name]
            IN VALUES ( Sellers[seller_name] )
    )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( Query1[seller_name] ),
        vProducts
    )

Pat

[amustafa70]

Thank you Pat, can I add a where clause to Sellers = DISTINCT(Query1[seller_name]) and the join is pct. So, competitors are same seller names with same pct codes minus the selected seller name