CIrcular dependency error while creating a calculated column

Question

Hello, I'm trying to calculate a column, simple steps

PRICE BRAND 1 = CALCULATE(SUM('PRICES'[PRICE]);FILTER(BRANDS;BRANDS[BRAND]="BRAND 1"))

And it works perfectly

Then I tried for the second brand

PRICE BRAND 2 = CALCULATE(SUM('PRICES'[PRICE]);FILTER(BRANDS;BRANDS[BRAND]="BRAND 2"))

and it gives me an error

" A circular dependency was detected: PRICES[Column], PRICES[PRICE BRAND 2], PRICES[Column]. "

Could you please helpme to solve this?

hotchilli · Answer

The simplest solution is to create these formulas as measures rather than calculated columns

Forum Discussion