Circular Dependency in Calc Columns with USERELATIONSHIP & ALLEXCEPT

I've went around and around and I cant figure this circ dependancy out. I'm trying to create two calculated columns. '2023 Referral ACV' and '2024 Referral ACV'. The 2023 worked fine, the 24' is giving me the dependancy error.

I've used both of the following SQLBI references.

https://www.sqlbi.com/articles/understanding-circular-dependencies/

https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

2024 Referral ACV = // Returns Circular Dependancy

CALCULATE(

        SUM(Opportunity[Referral ACV]),

        Opportunity[close_year__c] = 2024,

        USERELATIONSHIP(Account[Acct Id], Opportunity[Channel_Referral_Firm.sf18id]),

        ALL(Opportunity[Referral ACV])

)

2024 Referral ACV = // Version 2, Doesnt give me the Dependancy error but I get the same repeating Total down the column

CALCULATE(

        SUM(Opportunity[Referral ACV]),
        Opportunity[close_year__c] = 2024,

        USERELATIONSHIP(Account[Acct Id], Opportunity[Channel_Referral_Firm.sf18id]),

        ALLEXCEPT(Opportunity, Opportunity[Referral ACV]))