Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have 3 shared columns between two data tables. I need to keep the data tables separate as they are different data as well as separate API connections.
For discussion, we will call the tables: Table 1 and Table 2, and the shared columns, SharedColumn1, SharedColumn2 and SharedColumn3.
I was able to create a table to use SharedColumn1 as a filter for Table 1 and Table 2 like so:
If I understand correctly, you want to create two relationships between two tables. In general, there can only be one active relationship between two tables. If there are multiple relationships, they need to be set to inactive. In addition, specific Cross-filter instructions may lead to errors.
The following documents are available for your reference:
You can use the following function to specify the relationship to be used in a particular calculation.
USERELATIONSHIP function (DAX) - DAX | Microsoft Learn
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks @v-xuxinyi-msft ,
I don't necessarily want to use multiple relationships, this was just the method I attempted for my problem. I ultimately just want to be able to filter my two separate tables by 3 shared columns between them.
The end result will be a page with two matrix visuals (one for each table) and 3 slicers at the top (the shared columns) that filter both matrix visuals at the same time.
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |