Visual filtering based on slicer selections

Question

We are trying to solve the problem where we have the following:

Primary Product Selection slicer (single select)
- Which gives the data of customers, Product and sales who bought the particular chosen Product from the Primary Product Selection slicer
Secondary Product Selection slicer (multi- select)
- Captures the customers who did not buy the products chosen from the Secondary product selection slicer

Below is the sample model

Expected table visual is highlighted in green in the above screenshot.

Thanks.

anonymous · Accepted Answer

Hi&nbsp;RVK&nbsp;,Here is my test dataset:

I created two identical tables to create the slicer:

&nbsp;
The relationship is shown in the figure below:

Create three measures below:
Measure a =
CALCULATE(
    DISTINCTCOUNT(Sales[CustomerID]),
    'Sales'[ProductID] = SELECTEDVALUE('Product'[ProductID])
)Measure b =
CALCULATE(
    DISTINCTCOUNT(Sales[CustomerID]),
    'Sales'[ProductID] = SELECTEDVALUE('Product2'[ProductID])
)measure = 'Sales'[Measure a] + 'Sales'[Measure b]
Make the settings as shown in the following figure:
The results are as follows: