Forum Discussion

Sai_Alkesh's avatar
Sai_Alkesh
Helper II
6 years ago
Solved

Data Relationships

Hello, I have the following tables: 1. CC_Master (Includes unique cost center records columns - Cost_Center (numeric), and TM1_CC_Lookup (AlphaNum) 2. FIT table (transaction table), which includes...
General Comment
Need Help
Tips and Tricks
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi Sai_Alkesh ,

     

    I have shared the solution for your issue with the pbix file as a private message.

    Please check if that works.

     

    Thanks,

    Pragati

Pragati11's avatar
Pragati11
Super User
6 years ago

Hi Sai_Alkesh ,

 

Try making your relationships bi-directional and see if it works.

 

Thanks,

Pragati

  • Sai_Alkesh's avatar
    Sai_Alkesh
    Helper II
    6 years ago

    Hello Pragati11 

     

    Thanks for the quick reply.

     

    If i change the cardinality to bi-directional, then the values in FIT table are all wrong, as it sums up and it still doesnt filter the SAP table.

     

    Regards

    Sai.

    • Pragati11's avatar
      Pragati11
      Super User
      6 years ago

      Hi Sai_Alkesh ,

       

      Is there a way you can create a relationship between FIT and SAP table?

       

      Thanks,

      Pragati

      • Sai_Alkesh's avatar
        Sai_Alkesh
        Helper II
        6 years ago

        Hello Pragati11 

         

        I can establish relationship between FIT & SAP and tried that too, however filtering issue still persists & to arrest circular referencing, i need to de-activate one of the active links between FIT & CC_Master & SAP

         

        Regards

        Sai