Forum Discussion
Filtered Table filtering other tables in visualization
Hey everyone!
I created a Calculated Table with DAX. This table is filtered according to multiple criterias. (Article number and then all the components of this article.) This table returns a list of text values. (A table with the filtered columns.)
What I want to achieve is to take this returned list, and then filter 3 other tables. (Search for the 1 or more text values in the related column, and return the specified information in other columns).
If have a relationship between my DAX table, and the other three tables I wish to filter. If I click on one of the records in the DAX table, then it filters the three other tables, but the problem is I don't only want to search for one value but for many (all the records displayed in the DAX table). In some cases there could be a couple hundred values, and control-clicking would not be an option. (Control-clicking and selecting multiple values is the only sollution I found until now)
Thank a lot for your help
Daniel
Hi everyone
After a week of trial and error, and with the support of MFelix I was able to find a sollution to my problem.
What I did:
I duplicated my original table three times. Merged these tales with the three other tables I wanted to filter. Then I seperately created a measure for all these tables, and used this measure as a filter in these tables.
Thats how I was able to achieve the results I wanted
Thanks for reading!
7 Replies
- MFelix
Super User
Hi Anonymous ,
Can you please elaborate a little bit more and what you want to achieve?
To what I can understand you are trying to select certain values from a list (a calculated table on DAX) and then find the related values on 3 other tables?
Do you want to have this by user selection or by all the values on your table?
One option can be create a LOOKUP formula that returns all the values that matches the values.
Can you share a sample and expected result please?
Thanks for your reply
Ill try to visualize what I want:
DAX Table (filtered by slicers and filters)
Index Article Description Level
23 123-yB description 2
24 456-98 description 3
25 56GB-1 description 3
...
Stock Table
Article Description ...
123-yB tzja
456-98 hjasdkl
56GB-1 hjasdf
...
Delivery Table
Article ...
123-yB
456-98
56GB-1
Production Table
Article ...
123-yB
456-98
56GB-1
All tables contain the Article column. I want to get the list of articles from the filtered DAX table and use them to filter the other three tables. (I already have a relationship between the tables)
thanks again
- MFelix
Hi Anonymous ,
If you already have the relationship between the 4 table what you need to be sure is that the DAX table is the common base between all other tables and use the Article from that table on the visuals you are using and/or measures.
I assume that the relationship is one to many with the other tables.
However what I'm not understanding on your question is this paragraph
"In some cases there could be a couple hundred values, and control-clicking would not be an option. (Control-clicking and selecting multiple values is the only sollution I found until now)"
What do you mean by the filtering how do you want to have this filtering done without the ctrl click? one option can be placing article on a slicer that allows you to have a check box without the use of control.
Sorry for making this question but not really grasping what is the problem you are getting.
Hi everyone
After a week of trial and error, and with the support of MFelix I was able to find a sollution to my problem.
What I did:
I duplicated my original table three times. Merged these tales with the three other tables I wanted to filter. Then I seperately created a measure for all these tables, and used this measure as a filter in these tables.
Thats how I was able to achieve the results I wanted
Thanks for reading!
