Hi , i'm currently using lookupvalue on some calculated columns and i can't seem to understand as to why the circular dependency is happening. Screenshots:
Any help would be highly appreciated.
Thank you
Hi @PaulDBrown. The video was very clear and I was able to understand why it was happening. That calculated column and the lookupvalue had all the columns from the table BALANCETES depending on it, which means when calculating CVEE-FC it was including the CSEP column.
All i had to do was adding CALCULATE and ALLEXPECT to reduce the columns to what i wanted.
Printscreen:
Thank you so much, this was bothering me for a long time.
@Gonqq Is Regras[CVEE- FC] a calculated column?
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!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
Hi @Greg_Deckler . Regras[CVEE- FC] is a column from the Table Regras which i import from excel.
Screenshot of a part of table Regras:
Hi @PaulDBrown. The video was very clear and I was able to understand why it was happening. That calculated column and the lookupvalue had all the columns from the table BALANCETES depending on it, which means when calculating CVEE-FC it was including the CSEP column.
All i had to do was adding CALCULATE and ALLEXPECT to reduce the columns to what i wanted.
Printscreen:
Thank you so much, this was bothering me for a long time.
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
