Forum Discussion
Filtering Filter That Contains Product Name
Hey All, I have a shopping list of different customers. ID Products Bought 1 Prod_1 1 Prod_2 1 Prod_3 1 Prod_4 2 Prod_3 2 Prod_3 3 Prod_2 3 Prod_3 I want ...
Hi Anonymous ,
Try this:
1. Create another product table for slicer and do not create relationships with other tables.
Product = DISTINCT('Table'[Products Bought])2. Create a measure and use it as a visual filter, set as "is not blank".
Measure = VAR SelectedProduct = VALUES ( 'Product'[Products Bought] ) VAR t = SUMMARIZE ( FILTER ( ALL ( 'Table' ), 'Table'[Products Bought] IN SelectedProduct ), [ID] ) RETURN IF ( MAX ( 'Table'[ID] ) IN t, 1 )Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Hi Anonymous ,
Try this:
1. Create another product table for slicer and do not create relationships with other tables.
Product = DISTINCT('Table'[Products Bought])
2. Create a measure and use it as a visual filter, set as "is not blank".
Measure =
VAR SelectedProduct =
VALUES ( 'Product'[Products Bought] )
VAR t =
SUMMARIZE (
FILTER ( ALL ( 'Table' ), 'Table'[Products Bought] IN SelectedProduct ),
[ID]
)
RETURN
IF ( MAX ( 'Table'[ID] ) IN t, 1 )
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Perfect! Thank you very very much