Forum Discussion
Map with Multiple Relationships
Hello everyone, I am a recent user of Power BI and I need some help with this case. I am working with two tables. First one contains three columns: Origin, Destination, Issue (can have repe...
Let the relationship between Origin and Location be inactive (that will be in the form of dotted lines) ... you can easily plot the map between Destination and Location as the reltionship between them is active.
You can write a measure to make the particular relationship(Origin and Location) active by using USERRELATIONSHIP.
Origin and Location:= CALCULATE(VALUES(Tabel1[Origin]),USERRELATIONSHIP(Tabel1[Origin],Table2[Location]))...
This will make the inactive relationship active for this particular measure only...
Give this a try...