Forum Discussion
uphill filtering when using two data tables
Hi, Having a problem which may be as much a methodology issue as a technical one. i have a scenario where i use key tables to filter 2 data tables simulateously. [Data table1]*----1[key t...
This is effectively a many to many pattern. Have a read of my article here explaining how to push a filter from one data table onto anoher lookup table. The examples are not quite the same, but the principle is.
https://exceleratorbi.com.au/many-many-relationships-dax-explained/
Thanks for the link, i have been reading it.
Has this scenario come about (in my case) from poor design, or is it something fairly typical?
Im trying to get my head around the above.
I can filter using my key tables, it just means the end user has to scroll through lots of fields that arent necessary.
i will attempt to work through your article. I admit i struggle with 'Calculate' but also know i need to get more famililar with it