Manage Relationships between Tables

[Anonymous]

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

@Ashish_Mathur 

Thanks,

Dharani

[Ashish_Mathur · Accepted solution]

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.