I have a table, Table, with key, [Key], and a ref column, [Parent]. [Parent] references rows in Table 1.
I have a virtual column in Table, [Ancestors]. It throws an “Expression appears to be part of a cycle” error when using this formula:
[Parent].[Ancestors]
Even if [Ref 1] =/= [Key 1].
I tried this and it got the same error:
IF(
OR(
[Parent]=[Key],
ISBLANK([Parent])
),
LIST(),
[Parent].[Ancestors]
)
It seems like I should be able to access a value from the same virtual column, but a different row without a circular reference.
User | Count |
---|---|
36 | |
31 | |
28 | |
23 | |
18 |