how to remove A circular dependency

Hi, hchauhan556 

To remove circular dependency, you can rewrite the calculation logic of LastMonthInventory in Inventory in Ending Inventory to avoid using Inventory directly. For example, redefine and use CurrentMonthInventory in Ending Inventory instead of AdjustedInventory1. The following is a reference DAX expression:

EndingInventory =
VAR InvoiceQty =
    SUM ( 'InvoiceVolumeReport'[Invoice Quantity] )
VAR ForecastedQty =
    SUM ( 'Demand'[ForecastedQty] )
VAR CurrentMonthInventory =
    SUM ( CurrentInventory[Quantity] )
VAR PackagingValue =
    SUM ( 'Packaging'[Value] )
RETURN
    IF (
        InvoiceQty > ForecastedQty,
        CurrentMonthInventory + PackagingValue,
        CurrentMonthInventory - ForecastedQty + InvoiceQty + PackagingValue
    )

I hope the above DAX can be helpful to you.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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