How to have 2 Realationship active at the same time

[javieezy]

Hi Dear, 

As picture, I want both POD and POL of "StatistcLd" to have active relationship with "PortName" at the same time. 

Column looks like this: 

It doesnt reconize port code from Panama because its not active

Any way to do it except by merging 2 tables?

TIA

[Tahreem24]

@javieezy  like @DOLEARY85 said you can not have two relationship active at the same time.  A workaround is to utitlize USERELATIONSHIP dax to make them active at the time of calculation.

[DOLEARY85]

Hi,

You cant have them active in the model at the same time but any measures you create you can use ACTIVERELATIONSHIP within DAX to activte them both at the same time for that calculations/column

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[javieezy]

Thx! How to use calculation if i want to view it as matrix?