Filtering Visuals based on other filters

[RVK]

We are trying to solve a problem which involves following steps.

Step 1: First product slicer selection which will filter the table visual for sales related to chosen product.

Step 2: Second step need to fulfill following operations

1. Another Product slicer selection which will capture the customers who did not purchase the chosen products.
2. Removes the customers identified in the above step (2.i) from visual created in Step 1.

Below is the sample model

Thanks.

[Anonymous · Accepted solution]

Hi @RVK ,

Below is my table:

The following DAX might work for you:

Measure = 
    VAR cor = SELECTEDVALUE('Product'[Product ID])
    var name1 = SELECTEDVALUE('Customer'[Customer Name])
    var CID = SELECTEDVALUE(Sales[CustomerID])
    var result1 =
      not(
        CALCULATE(
            SUM(Sales[Sales]),
            FILTER(Sales , Sales[ProductID] = cor)
      )
      )
     RETURN
        IF(result1 = true ,cor,BLANK())

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.