Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

RANKX Circular Reference Error

I am getting a circular reference error in my RANKX column AreaCluster Rank = RANKX(     FILTER(         ALL('Table'),         'Table'[Area] = EARLIER('Table'[Area])     ),     [Table Ove...
Need Help
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
2 years ago

"[Table Overall Score] measure is basically "<-- this will be the problem.  It is not a good idea to use measures in calculated column definitions.  Measures are dynamic and for visuals. They can give results in columns but not a good idea.