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

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

    • Pragati11's avatar
      Pragati11
      Super User
      6 years ago

      Hi Sai_Alkesh ,

       

      Yes you will have to de-activate the relationship between CC-Master and FIT.

       

      Thanks,

      Pragati

      • Sai_Alkesh's avatar
        Sai_Alkesh
        Helper II
        6 years ago

        Hello Pragati11 

         

        I did that too. Below is the modified relationship table. After modifying, SAP table still doesnt filter based on value selected in FIT table

         

         

         

        Regards

        Sai