Circular reference: SELECT function
Hello, I'm currently working on a module, where one of the Rate list items is a difference of the other two, indicated in bold. The problem that occurs here is that I receive a circular reference error, because I'm changing the line item 'Prepay (Partial)'. However it would never circular refer to itself, because of the IF Function. Is there a way to override this error or a better way to select the two numbers from the other Rate list items? IF ITEM(Rates) = Rates.Margin THEN 'Gemidd.Enc Previous YTD'[SELECT: Rates.Client Rate] - 'Gemidd.Enc Previous YTD'[SELECT: Rates.FTP] ELSE IF ITEM(Rates) = Rates.Margin Net of LP THEN 'Prepay (Partial)'[SELECT: Rates.Margin] - 'Prepay (Partial)'[SELECT: Rates.Liquidity Premium] ELSE 'Gemidd.Enc Previous YTD'