Forum Discussion

DataUsurper's avatar
DataUsurper
Icon for Helper II rankHelper II
6 years ago

Create Measure to Avoid Circular Dependency

Hello All  o/   So, the backstory: We have determined approximately 40% of our orders have the pricing and totals zero'd out (whooooooole nother story), what we're wanting to do is create a calc to...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi DataUsurper ,

 

If the calculation of the result you want involves circular iteration, DAX cannot solve this kind of problem for the time being. It is recommended that you use Python or R to solve the problem.

Could you share the sample pbix through OneDrive for Business to see if we can avoid circular dependency.

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.