Forum Discussion

javieezy's avatar
javieezy
Icon for Helper I rankHelper I
3 years ago

How to have 2 Realationship active at the same time

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

Need Help

3 Replies

  • DOLEARY85's avatar
    DOLEARY85
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    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's avatar
      javieezy
      Icon for Helper I rankHelper I
      3 years ago

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

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    3 years ago

    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.