Filter column based on 2-value combination from another table

[simple_user]

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.

[Anonymous]

Hi @simple_user 

Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[simple_user]

I made an example, but I have a stupid question.
How do I upload it ??
I am new to this forum.

[foodd]

You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

[simple_user]

This works exactly how i want it to worlk:
https://drive.google.com/file/d/1Ar4E-C12Dbc46Fpl26VaYqa3voEey-iR/view?usp=sharing
for a short amount of lines .....
from a slicer, i apply "and" logic and pass the selected ids into a string

If I create a calculated column, i believe it would be static, but I want dynamic metrics. Hence I use measures
can I replace the string "selected ids" with something else ??

for big datasets the metrtics/visuals take up to 5 minutes to load