Forum Discussion
Data Relationships
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
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
Hi Sai_Alkesh ,
Yes you will have to de-activate the relationship between CC-Master and FIT.
Thanks,
Pragati
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
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
- From which table the highlighted columns are used for filtering? (RED highlighted)
- Can you share some screesnhots of visualisations and slicers/filters you are using in Power BI?
- Is there Cost Element column in SAP table?
Thanks,
Pragati
Hello Pragati11
The filters are applied from CC_Master (for Cost Center, Country) & from
FIT table for Currency, Cost element
Regards
Sai