Exclude and Include Slicer

[gussie]

Hi Everyone,

I am at a roadblock in a current assignment... I have a product matrix that includes:

	Product A	Product B	Product C	Product D
Customer 1	1		3	2
Customer 2	2	1		1

INCLUDE SLICER: I would like a filter that if I select it shows me if customer has Product A and Product B then it will show:

	Product A	Product B	Product C	Product D
Customer 2	2	1		1

EXCLUDE SLICER: I would also like a filter that shows me if a customer does not have a certain product. For example a slicer if I select Product B it will show:

	Product A	Product B	Product C	Product D
Customer 1	1		3	2

I have the measure for each product calculating what products each customer has. If a customer doesn't have a certain product it is blank. Am I doing this correctly? How would I go about a exclude and include slicer 🙂

active_product_a = 

VAR A = CALCULATE( SUM( fact[qty] ),

 ALL(fact), 

 VALUES(dim_customer[customer_name]),

 fact[product_type] = "A"

 )

RETURN

IF( A = 0, BLANK(), A)

[amitchandak]

@gussie , I have discussed this using an independent table in my video

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

[gussie]

I don't want to use an independent table, I want to use the same table.

Thanks 🙂

[Anonymous]

Hi @gussie ,

You will need an independent table. If you use the same table, the slicer will also filter the visual.

Best Regards,

Jay