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 

 

The filters are applied from CC_Master (for Cost Center, Country) & from

FIT table for Currency, Cost element

 

Regards

Sai

Pragati11's avatar
Pragati11
Super User
6 years ago

Hi Sai_Alkesh ,

 

I still don't see any screeshots in your reply.

Please make relationship between CC_Master and SAP bi-directional, as you are trying to filter data in SAP table using filters from CC_Master.

 

If still doesn't work, try sharing your pbix file.

 

Thanks,

Pragati

  • Pragati11's avatar
    Pragati11
    Super User
    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 

     

    Thank you so much. This now works.🙂

     

     

    Regards

    sai.