Forum Discussion

Etienne123's avatar
Etienne123
Icon for Advocate II rankAdvocate II
6 years ago
Solved

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 thi...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    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.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

     

     

Etienne123's avatar
Etienne123
Icon for Advocate II rankAdvocate II
6 years ago

Before I saw this, I ended up doing somethikng similar to the PQ soluition, but I really like the DAX UNION method.

 

Thanks!!

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

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.

  1. Most of the time your model gets better compression rates than when using DAX columns/tables.
  2. 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