@Anonymous In that case, then you need to create a lookup table with the all the columns you want to link with for a particular code (which you are using in the dropdown).
For Example :
Then link this lookup table to the main table (which you need to unpivot as per the link posted above). You might need to have a bridge table to avoid many to many relationships on columns link.
Please try and let me know how it goes !
Did I answer your question? Mark my post as a solution!
Proud to be a PBI Community Champion