Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Data Model - switch relation from inactive to active by condition.

Hi All,
I need your help in switch relation from inactive to active by condition.

 

I have 4 tables.


tabe 1:

table 2:

table 3:

filter:

Data Model:

 

dashboard:

 

I need to switch  filter from table 1 to table 2 according filter selection

 

link: Power BI WorkSpace

 

Hope for your help

 

Tks,

Idan

 

Need Help

19 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Greg,
      Tks For your respond.
      I saw USERELATIONSHIP Function Before I posted.


      I didn't understand how to use it.
      1.Where to put it -> table Active or table Inactive
      2.This function need Calculate formula -> However I don't have anything to put in

      3.Is a Measure or calculated column ?

       

       If you can, Pls help me to build the formula

       

      Tks A lot 

       

      Regards,
      Idan

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        7 years ago

        Quick question, why can't you just Append your Table1 and Table2 so that you eliminate the issue?