Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 Cost_center column and mapped to CC_Master on many to one. Cost_center column of FIT table connects to TM1_CC_Lookup column in CC_master & direction is single
3. SAP table (transaction table), which includes Cost_center column mapped to CC_Master on many to one, single direction. Cost Center column of SAP connects to Cost_Center column of CC_Master.
On my report, i have one matrix table getting data from FIT table, which includes Date, Cost center, currency, cost element, country etc., & on another table, i have SAP data.
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
Pasted below is my data
Appreciate if anyone could help me please.
Regards
Sai.
Solved! Go to Solution.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |