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:   dashboar...
Need Help
  • 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
      Icon for Community Champion rankCommunity Champion
      7 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        In this case I just simplified my tables.
        In reality I've 2 fact tables contain 500K Rows Each and I want to add filter which filter both.

         

        Thank you Greg for your kindness

         

        Idan