Forum Discussion

Denis_Slav's avatar
Denis_Slav
Helper III
5 years ago

Circular dependency Error

Hi All, 

How can I create relationship between "Data" and "Range" to use "Range"[Description] in slicer?

I have two tables. Data:

Value
1
5
3


"Range" diapasons

IDMinMaxDescription

1

01Name1

2

  Name2

3

   

 

I try to add column in "Date" and create reletionship between [IDRange] & [ID].

 

IDRange = 
CALCULATE(
    SUM('03-01 MT_SalaryRange'[RID]),
    FILTER(
        '03-01 MT_SalaryRange',
        '21-01 DS_Headhunter'[21-01 Salary Min Average] >= '03-01 MT_SalaryRange'[Min] &&
        '21-01 DS_Headhunter'[21-01 Salary Min Average] < '03-01 MT_SalaryRange'[Max]
    )
)

 

But has a error: "A circular dependency was detected"

Need Help

2 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    HI Denis_Slav 

    Not very clear.  You say that you have 2 tables called Data and Range but your measure mentions neither of these.  Your measure references tables that you haven't shown any data for.

    You say you try to add a column in Date - is that another table?

    [IDRange] is a measure - you can't create a relationship between it and anything else.

    I can't see from the info you have provided where the circular reference is occuring.

    Please try to restate the problem and provide the data you are using - preferably yout PBIX file.

    Regards

    Phil

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    Hi, Denis_Slav 

     

    Have your problem been solved? You should never use a measure inside a calculation of a calculated column, here it is also responsible for the circular dependency as the measure tries to average rows whereas the calculated column just wants to resolve the row context. 

    If you still need help, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.