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 ,

 

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

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi Sai_Alkesh ,

     

    A quick question on the following statement by you:

    When i apply filters from other organization values (country, Cost center, currency etc.,), and select cost element from FIT table, the corresponding SAP table filters data only to Cost Center, but not at the level of Cost element

     

    1. From which table the highlighted columns are used for filtering? (RED highlighted)
    2. Can you share some screesnhots of visualisations and slicers/filters you are using in Power BI?
    3. Is there Cost Element column in SAP table?

    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