Forum Discussion

Niels_NL's avatar
Niels_NL
Advocate I
10 years ago

Circular dependency detected

Hey guys,   Here's the situation: Customer table (customerID, revenue2014, revenue2015, revenue2016, revenueTotal) CustomerBase table (customerID, customerName, etc.) Revenue table 2014 (custom...
Need Help
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
10 years ago

Hi Niels_NL,

Change the DAX expression of revenueTotal a little bit and your %_Share expression would work.

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



Regarding the circular depency, check Understanding Circular Dependencies in Tabular and PowerPivot.