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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
jovendeluna21
Helper IV
Helper IV

A circular dependency was detected: Sample[Comparable], Sample[Column 2], Sample[Comparable].

Hi, 

I need help on how can I fix this error:

jovendeluna21_1-1720504619318.png

 

 

I uploaded here the file:

https://drive.google.com/file/d/13mOcZwMqymf2cSguEtyEAHG74nnVwrpw/view?usp=sharing

 

Appreciate any help! Thanks!

2 REPLIES 2
Dangar332
Super User
Super User

Hi, @jovendeluna21 

Can you Clarify Your requirment what you want to achieve.
I take a look at your File and it's seems you refer measure in to column which is depend on slicer selection.

Hi, @Dangar332 .  I want to show the comparable spend for both selected years. Previously I just manually entering number instead of 'Last N'[Var] and somehow that works, however I want it to be dynamic based on selected Fiscal Year. Comparable column I used as filter and should be filtered to "Yes" to show comparable spend. For some reason, the created measure '00_Comparable USD Spend 2' doesn't work without the Comparable column filtered to "Yes".

 

jovendeluna21_0-1720508190090.png

 

 

jovendeluna21_1-1720508225559.png

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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