Circular dependency detected

Hey guys,

Here's the situation:

• Customer table (customerID, revenue2014, revenue2015, revenue2016, revenueTotal)
• CustomerBase table (customerID, customerName, etc.)
• Revenue table 2014 (customerID, ordertotal, etc.)
• Revenue table 2015 (customerID, ordertotal, etc.)
• Revenue table 2016 (customerID, ordertotal, etc.)

Relations are as followed:

• Revenue tables > Customer table (linked on customerID)
• Customer table > CustomerBase table (linked on customerID)

In the 'Customer' table I used some DAX measures to calculate the total revenue for each year and put them in the designated columns. Example of such a DAX measure:

revenue2014 = CALCULATE(SUM(tbl_revenue2014[ordertotal]);tbl_CustomerBase[customerID])

After doing this for each year, I created a DAX measure to sum 2014, 2015 and 2016 into a 'revenueTotal'. This one is as follows:

revenueTotal = CALCULATE(SUM(tbl_Customer[revenue2014])+SUM(tbl_Customer[revenue2015])+SUM(tbl_Customer[revenue2016]);tbl_Customer[customerID])

Now, after this, I'd like to create a new column containing a % of share in revenue for each customer. So "( total revenue generated by customer / total revenue of all ) * 100%".

I tried this DAX measure:

%_Share = tbl_Customer[revenueTotal]/SUM(tbl_Customer[revenueTotal])

But this gives me the error (translated from Dutch in English): 

" There is a circular dependency detected: tbl_Customer[revenueTotal], tbl_Customer[%_Share], tbl_Customer[revenueTotal] "

I can't seem to find what this error exactly means and how I can solve it or create a workaround. Anyone has any thoughts?

Thanks,

Niels