Forum Discussion

nisi's avatar
nisi
New Member
3 years ago

circle dependency

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!

Need Help
Tips and Tricks

6 Replies

  • bcdobbs's avatar
    bcdobbs
    Community Champion
    3 years ago

    Are you trying add calculated columns?

     

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

    • nisi's avatar
      nisi
      New Member
      3 years ago

      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's avatar
        bcdobbs
        Community Champion
        3 years ago

        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.