Hoping someone can assist in overcoming the dreaded circular reference error in DAX measures.
I'm re-building an excel file in Power BI. The circular ref excel file is a "very" cut down version of the original file. The columns in blue are data (only in the excel file - I have them as DAX in my Power BI file) and the others are measures.
In essence, I want to track what can be delivered based on what has:
With these 3 inputs, I have to calculate:
I have entered the excel formulae above the header row. Helping overcome circular reference would be a great quick measure to add to the quick measure toolkit available within Power BI.
Your help is greatly appreciated.
In your sample data, are there only 3 columns, AbilityToDeliver, ActualDeliver and Demand?
From your requirement, it should be have AbilityToDemand and ActualDemand. Please provide us more detail sample data, so that we can make further analysis.
Thanks for your response. I've updated the file with additional columns. This is the link
Demand is Orders (customer orders)
The spreadsheet has 2 worksheets. Version 1 is the original and Version 2 contains the additional and updated columns.
I've updated the column headers to be more descriptive.
Appreciate your assistance.