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)
