circle dependency

[nisi]

Hi,

I want to create a measure with the IF and SELECTEDVALUE function in DAX. To do this, the value from the previous calculated cell must be used in multiplication for each cell. In Excel it works great, in PBI I get the error message "Ring dependency". But I have to calculate the values ​​like this, there is no other way. How do I proceed? Thanks!

[bcdobbs]

Are you trying add calculated columns?

Can you provide some example data? And example of the output you need.

[nisi]

Hi, i am trying to add calculated measure. The best way to do this is to give the formula in Excel. For column D6 it is: =IF(A6=$A$9;100%;IF(A6<$A$9;D5*(1+C5);"")). So that means I need the values ​​from the previous cell to calculate the other cells. I have already defined columns A and C as a measure in PBI, I only have problems with D because I cannot refer to the entries in the formula. I would be really grateful if you can help me!

[bcdobbs]

Can you share an excel file with the same format but dummy data.

A measure doesn't inherently have a sense of row order so would need to understand more about what you're doing and what determines row order. Sure there are ways of achieving it but often need either an index column building or use of OFFSET. 

[nisi]

This is what I want to do:

Measure= IF(SELECTEDVALUE(QYear[QYear])=max(Index[Year]),100,IF(SELECTEDVALUE(QYear[QYear])<max(Index[Year]),(1+Index[IndexValues])*Index[Measure],BLANK()))

The Measures QYear, Year, IndexValues have already been created. "Index[Measure]" is the Problem

[v-zhangti]

Hi, @nisi 

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with Excel. I look forward to your response.

Best Regards,

Community Support Team _Charlotte

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

[nisi]

Hi,here are two screenshots of the file. I want to create the "Change" column in PBI as a measure or column with a formula. I have already created the other two columns. ("Wenn" means IF)

Thank you!