Filtering a table what is not filtered on the slicer

[jlostrom]

I am trying to create a Power BI Dashboard and am running into a road block.

We have monthly events that advisors can attend. These events relate to one, or a series of, products.

Then I would like to show 3 charts/graphs:

1. All sales of the advisors who attended
2. All sales of the products highlighted
3. All sales of the attending advisors and the highlighted products.

I have the following tables:

1. One for the events and the fund codes the event is highlighting.
2. One for the attended advisors to the event. It contains the key to link back to the event table.
3. A table with all sales (by month and product code). It has a link to the attended advisors, but not the events. But I do have a calculated column that populates the Event Key if the fund is a highlighted fund. But there is not direct link from Event to sales.

Event Key = lookupvalue('Event Products'[Event Key], 'Event Products'[Linked Fund], 'sales'[Product code])

                As an example this gives a 1 or 2 if the Product code links to the event. So Event 1 links to product code A10 and A101 and event 2 links to A11. A12 is not highlighted at all, so the event key is empty.

                My issue is displaying all sales related to the highlighted funds since there is not relationship. My slicer is on the “Events[Event Key]”. When I select an event: how can I filter on the measure sales[Event Key] when it contains the same value as the slicer?

My thought is if I could add a measure to the sales table I would like display a 1 or 0 if the row in the sales table is linked to the event in the slicer. My issue is referencing the selectedvalue or a column in Event.

Event Key Match = CALCULATE (

    MIN ( 'sales'[Event Key] ),

    FILTER (

        sales,

        and('sales'[Product code] IN VALUES ( 'Event Products'[Linked Fund]), 'sales'[Event Key] =  Selectedvalue(Event[Event Key] ) )

    )

)