Circular dependency Error

[Denis_Slav]

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

ID	Min	Max	Description
1	0	1	Name1
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"

[v-janeyg-msft]

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.

[PhilipTreacy]

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