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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
jaynesa
Helper II
Helper II

How do I get rid of this circular dependency??

I have two tables, "LPT P&B" and "P&L(2)".  I've created a weight function in the "LPT P&B" table, and want to multiply that weight against a P&B value, that's in my P&L table.  Attached to this are the formula's.  I've tried looking at different articles and solutions, but nothing seems to be working.  Please help!LPT Lookup.jpgP&B Table.jpg

2 REPLIES 2
v-shex-msft
Community Support
Community Support

HI @jaynesa,

I'd like to suggest you take a look at the following link first, it mentions the reason of circular dependency issue and how to avoid it:

Avoiding circular dependency errors in DAX 

If above not helps, please share a pbix file with some dummy data to test.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Greg_Deckler
Super User
Super User

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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