Forum Discussion

simple_user's avatar
simple_user
Frequent Visitor
2 years ago

Filter column based on 2-value combination from another table

Hello,
I have a table (Table1) with columns ID, Attribute, Value. This is a pivoted table of 200 columns and 3000 rows + an added index column.
Some Attributes may have  the same range of Values. Values can be anything, numbers or string. I treat all data as categorical.

Step 1:
I want to select specific Attribute-Value combinations dynamically.
To do that I created a copy of this table (Table2) and created a hierarchical slicer with the Attribute as category and Value as sub category.
The problem is that the slicer has an "OR" logic.
To bypass this I thought of applying myself an "AND" logic and return a string of the desired IDs.
Is my approach correct ?? Is there a better alternative  ??

Step 2:
Having the desired IDs from Table1, Iwant to filter the IDs from Table2. I also added a slicer that selects an Attribute from Table2 and a bar chart that plots the count of each value for the selected Attribute.

I need everything to be dynamic.
Any ideas/suggestions ??
THank you in advance.

4 Replies