Forum Discussion

liberty20's avatar
liberty20
Frequent Visitor
4 years ago

Column not found error!!

Hi All,
I am getting an error "[Overdue] column not found in the below formula", obviously because [Overdue] is the calculated measure which I have created.
 
(A Ranking is the calculated column)
A Ranking =
VAR MaxOverdue = MAX('Table1'[Overdue])
VAR PMultiplier = MaxOverdue+20000
VAR FMultiplier = MaxOverdue+10000
VAR ValNoDebt = MAX('Table1'[Debtor A])
VAR Result=
RANKX(
All('Table1'),
'Table1'[Overdue] + 'Table1'[A PTP Breach(1-Y 0-N)]*PtpMultiplier + 'Table1'[A Followup Breach(1-Y 0-N)]* FollowupMultiplier + 'Table1'[A PTP Breach(1-Y 0-N)]*PtpValue+ ValNoDebt
)
Return
Result
 
To make this formula work I need to create calculated column for [Overdue].
When creating column for [Overdue] it is giving me a circular depedency error & wrong values in [Overdue] column.
 
For Reference :
Measure : 
Overdue = CALCULATE(SUMX(FILTER('Table1', 'Table1'[RG] = "31 - 60 Days" || 'Table1'[RG] ="1 - 30 Days" ||'Table1'[RG] = "61 - 90 Days" || 'Table1'[RG] ="> 91 Days"), 'Table1'[Outstanding Amount]))
 
Kindly help me to create calculated column for [Overdue] to get correct values in column, to make Ranking work & to avoid circular dependency.
 
Thanks in Advance!
 
 

2 Replies

  • rbriga's avatar
    rbriga
    Impactful Individual
    4 years ago

    It Happens since it's not a column. If you're looking for the MAX Overdue among the rows in table 1, try:

    VAR MAXOVERDUE = 
MAXX(
 Table1,
 [Overdue]
)

     

    If you're looking for the max overdue among customers, try 

    VAR MAXOVERDUE = 
MAXX(
 VALUES(Table1[Customer ID]),
 [Overdue]
)
  • liberty20's avatar
    liberty20
    Frequent Visitor
    4 years ago

    rbriga Thank you for your quick response!

    I have tried above solution but it's not working in my case.

    Still getting circular dependency error in my Ranking formula.

     

    Kindly help me to create calculated column for MAX of Netoverdue (Note that Netoverdue is the calculated column I have created)

    Netoverdue = measure1+measure2+measure3