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 Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
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.
