Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
0XMaijeh
Frequent Visitor

HELP WITH CIRCULAR DEPENCENCY ISSUES

I want to create a measure called Products Available => It is derived from [Product Opening Balance] and just gives me the closing balance for the previous month as the opening balance of the new month. That is why I have this measure; Product Opening Balance = VAR PreviousClosingBalance =
CALCULATE([Product Closing Balance], DATEADD('Calendar'[Date], -1, MONTH))
RETURN
IF(PreviousClosingBalance < 0, BLANK(), PreviousClosingBalance)

I now want to add [Product Opening Balance] to two other measures to make create the [Products Available] measure => ([Company SKUs] and [Monthly Forecasted Returns).

Recall I said [Product Opening Balance] is determined by [Product Closing Balance]. The DAX for Product Closing Balance = [Product Opening Balance] - [Product Demand]. When I add [Product Opening Balance] + [Company SKUs] + [Monthly Forecasted Returns] to get Products Available, I run into a circular dependency issue.

Which I think is caused by [Product Opening Balance] being determined by [Product Closing Balance]. Please What do I need to do to avoid this, kindly recommend the most efficient DAX code to solve this problem.

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Hi,

Share the dowload link of the PBI file and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi Ashish, unfortunately I couldn't share the EXACT pbix due to data privacy. However, I'll attach what I hope to achieve, thanks a lot!

https://drive.google.com/drive/folders/1auVqelWMCHiYW6UVGmsGIirp9acWx5RP?usp=sharing

Hi,

I do not understand your question at all.  Show the expected result very clearly.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors