Forum Discussion
RevOps608
Helper II
Helper IICircular 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 givi...
Figured it out. I read through this other post a ton but I was using 'ALL' wrong. Boom, winner.
https://community.fabric.microsoft.com/t5/Desktop/ALLEXCEPT-USERELATIONSHIP/m-p/517611
2024 Referral ACV =CALCULATE(SUM(Opportunity[Referral ACV]),Opportunity[Close_Year__c] =2024,USERELATIONSHIP(Account[Acct Id], Opportunity[Channel_Referral_Firm.sf18id]),ALL(Account[2023 Referral ACV]))
RevOps608Helper II
Helper IIFigured it out. I read through this other post a ton but I was using 'ALL' wrong. Boom, winner.
https://community.fabric.microsoft.com/t5/Desktop/ALLEXCEPT-USERELATIONSHIP/m-p/517611
2024 Referral ACV =
CALCULATE(
SUM(Opportunity[Referral ACV]),
Opportunity[Close_Year__c] =2024,
USERELATIONSHIP(Account[Acct Id], Opportunity[Channel_Referral_Firm.sf18id]),
ALL(Account[2023 Referral ACV]))