Forum Discussion
Display Values that share same values across three different columns
Hello,
I Have a Table that is similar to the one below:
| Product ID | Product Type | Product Location | Product Color |
| A | WIDGET | NY | BLUE |
| B | WIDGET | CA | RED |
| C | WIDGET | NYC | BLUE |
| D | SERVER | CA | GREEN |
| E | SERVER | CA | GREEN |
| F | PC | FL | RED |
What I'm trying to do is set the filter on a dashboard by Product ID, where it displays all Products that share the same Product Type, Product Location and Product Color.
For Example:
If I Select Project A, it will display:
| Product ID | Product Type | Product Location | Product Color |
| A | Widget | NY | Blue |
| C | Widget | NY | Blue |
Any help will be greatly appreciated.
Thanks
Hi Anonymous ,
I have created a sample for your reference. Please check the following steps as below.
1. Create a calculated table and make it as slicer.
Slicer = DISTINCT(Query1[Product ID])2. New a measure and make the table viusal filtered by it.
Measure = VAR pro = SELECTEDVALUE ( Slicer[Product ID] ) VAR color = CALCULATE ( MAX ( Query1[Product Color] ), FILTER ( ALL ( Query1 ), Query1[Product ID] = pro ) ) VAR loc = CALCULATE ( MAX ( Query1[Product Location] ), FILTER ( ALL ( Query1 ), Query1[Product ID] = pro ) ) VAR ty = CALCULATE ( MAX ( Query1[Product Type] ), FILTER ( ALL ( Query1 ), Query1[Product ID] = pro ) ) RETURN IF ( MAX ( Query1[Product Color] ) = color && MAX ( Query1[Product Location] ) = loc && MAX ( Query1[Product Type] ) = ty, 1, 0 )Pbix as attached.
2 Replies
Hi Anonymous ,
I have created a sample for your reference. Please check the following steps as below.
1. Create a calculated table and make it as slicer.
Slicer = DISTINCT(Query1[Product ID])2. New a measure and make the table viusal filtered by it.
Measure = VAR pro = SELECTEDVALUE ( Slicer[Product ID] ) VAR color = CALCULATE ( MAX ( Query1[Product Color] ), FILTER ( ALL ( Query1 ), Query1[Product ID] = pro ) ) VAR loc = CALCULATE ( MAX ( Query1[Product Location] ), FILTER ( ALL ( Query1 ), Query1[Product ID] = pro ) ) VAR ty = CALCULATE ( MAX ( Query1[Product Type] ), FILTER ( ALL ( Query1 ), Query1[Product ID] = pro ) ) RETURN IF ( MAX ( Query1[Product Color] ) = color && MAX ( Query1[Product Location] ) = loc && MAX ( Query1[Product Type] ) = ty, 1, 0 )Pbix as attached.