- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Need help with DAX and visuals to highlight relationships between two values
Hi
I have a single table with Value1 and Value2 values, for example:
Value1 - Value2
A - B
B - C
B - D
C - E
The relationships do not apply in a particular direction, and visualising this using something like a Forced-Directed Chart shows the relationships quite well. You can see how it shows all the relationships with B, irrespective as to whether B is in Value1 or Value2.
But the data needs to be filtered by B and if I base the filter on Value1, then I will only see the relationships with C and D, and conversely, if I base the filter on Value2, then I will only see the reltionship with A. I need to be able to select B and show A, C and D.
I think what I need do is to ensure all distinct values across Value1 and Value2 and represented in (for example) Value1 and for all its relationships to appear in Value2. Something like
Value1 - Value2
A - B
B - A
B - C
B - D
C - B
C - E
D - B
E - C
Is this the solution, and could such a dataset be derived?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Etienne123
The solution you have suggested is presumably the best, and it's easy to achieve both in Power Query and using DAX.
I've attached a file with both solutions, let me know if you need any explanation.
Mariusz
If this post helps, then please consider Accepting it as the solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Etienne123
The solution you have suggested is presumably the best, and it's easy to achieve both in Power Query and using DAX.
I've attached a file with both solutions, let me know if you need any explanation.
Mariusz
If this post helps, then please consider Accepting it as the solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Before I saw this, I ended up doing somethikng similar to the PQ soluition, but I really like the DAX UNION method.
Thanks!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Etienne123
I'm glad you like it, just a few things to pint out here, the best practice is to do your transformation is PQ.
- Most of the time your model gets better compression rates than when using DAX columns/tables.
- You can load only one result table ( saves the model size and removes unnecessary objects )
However, with smaller models, it shouldn't make much of a difference.
Thanks
Mariusz

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-30-2024 12:17 PM | |||
08-27-2024 08:40 AM | |||
03-08-2024 03:13 AM | |||
09-06-2024 04:51 AM | |||
07-19-2024 12:56 PM |
User | Count |
---|---|
33 | |
18 | |
14 | |
11 | |
10 |