Forum Discussion
Manage Relationships between Tables
Hi,
I have two tables called loans and Incentives.
I loaded the loans table initially and then the incentives table. An relationship was auto detected based on a common column in both the table.
The incentive tables had other columns with data type as whole number.
I placed all those columns in a table and enabled the totals which wasn't displaying. But later after removing the relationship, it displays the totals as expected. why is that happening? can anyone help me with that ?
Here is the link to the pbix file
https://drive.google.com/drive/folders/1o_Vj-nl6ilxrx3WJzo-s6oP9J-w3rcYR?usp=sharing
Please Help
Thanks,
Dharani
Hi,
What exactly are you trying to do? When i open the file, i do not see any problem (and the relationship is intact). Furthermore, you should select the first 3 columns in the Incentives table and select "Unpivot Other columns". You should should create a Dimension table of Office_uuid and then build a relationship (Many to One and Single) from the office_uid of the Incentives and Loans table to the dimension table.
1 Reply
- Ashish_Mathur
Super User
Hi,
What exactly are you trying to do? When i open the file, i do not see any problem (and the relationship is intact). Furthermore, you should select the first 3 columns in the Incentives table and select "Unpivot Other columns". You should should create a Dimension table of Office_uuid and then build a relationship (Many to One and Single) from the office_uid of the Incentives and Loans table to the dimension table.