Forum Discussion
Lookup and List.Distinct, List.Sort within same table
In my content management system, I can make a relationship between table rows (and their respective IDs). The original or "base" table is Table 1, and it contains all rows. I've replicated th...
1. PBIX file is not attached.
2. I have a follow up question. Will it have a cascading impact through relationship. For example, 4 is related to 1 which is in turn related to 2 & 3. Hence, will the output of 4 contain elements from 2 & 3 as well.
Hello, Vijay. Great questions.
No - there's no expectation for cascading relationships (or any expectatation that they be queried, for that matter).
Apologies - seems I can't upload the sample PBIX.
For context, I've tried to merge and append tables to create a unified solution, but without much luck; and I've attempted a few LOOKUPs and SELECTEDVALUE measures, but no luck there, either. Nor with CONTAINS, but I believe that only returns True(), rather than values (?).