Column not found error!!

[liberty20]

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!

[liberty20]

@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

[rbriga]

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]
)