I want to remove Sort By under Column Tools

Question

I have four calculated columns and a table.

Baseline Incurred and Net Incurred formulas are the exact same except for the financial field referenced. The fields referenced are the same formats (currency, summarize).

Baseline Incurred Sort and Net Incurred Sort calculated columns are the exact same.

The Baseline Incurred and Baseline Incurred Sort work perfectly. The Net Incurred and Net Incurred Sort are not sorting properly, even though they look fine in the table as far as what they are returning.

After troubleshooting many times, the only thing I can find is that the new calculated column (Net Incurred) has automatically defaulted to sort by itself, whereas Baseline Incurred doesnt have anything highlighted (see below).

Is there a way to remove this sort by? I cannot find the option anywhere. I've already tried deleting and recreating this column.

Before you say "it should be using the sort by column", it can't because it creates a circular dependency even though these are referencing a sorting table. I've been going in circles with this and can't figure out why the older formulas for Baseline work but the Net Incurred ones don't.

Here are the formulas:

Baseline Incurred Stratification =

VAR IncurredAmount = [Baseline Incurred]

RETURN

IF(

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort],11),

LOOKUPVALUE('Incurred Lookup'[Stratification], 'Incurred Lookup'[Sort],11),

IF(

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort],10),

LOOKUPVALUE('Incurred Lookup'[Stratification],'Incurred Lookup'[Sort],10),

IF(

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort],9),

LOOKUPVALUE('Incurred Lookup'[Stratification],'Incurred Lookup'[Sort],9),

IF(

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort],8),

LOOKUPVALUE('Incurred Lookup'[Stratification],'Incurred Lookup'[Sort],8),

IF(

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort],7),

LOOKUPVALUE('Incurred Lookup'[Stratification],'Incurred Lookup'[Sort],7),

IF(

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort],6),

LOOKUPVALUE('Incurred Lookup'[Stratification],'Incurred Lookup'[Sort],6),

IF(

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort],5),

LOOKUPVALUE('Incurred Lookup'[Stratification],'Incurred Lookup'[Sort],5),

IF(

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort],4),

LOOKUPVALUE('Incurred Lookup'[Stratification],'Incurred Lookup'[Sort],4),

IF(

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort],3),

LOOKUPVALUE('Incurred Lookup'[Stratification],'Incurred Lookup'[Sort],3),

IF(

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort],2),

LOOKUPVALUE('Incurred Lookup'[Stratification],'Incurred Lookup'[Sort],2),

LOOKUPVALUE('Incurred Lookup'[Stratification],'Incurred Lookup'[Sort],1) // The first stratification level

))))))))))

-------- Next Formula -------

Net Incurred Stratification =

VAR IncurredAmount = [Net Incurred]

RETURN

IF(

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort],11),

LOOKUPVALUE('Incurred Lookup'[Stratification], 'Incurred Lookup'[Sort],11),

IF(

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort],10),

LOOKUPVALUE('Incurred Lookup'[Stratification],'Incurred Lookup'[Sort],10),

IF(

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort],9),

LOOKUPVALUE('Incurred Lookup'[Stratification],'Incurred Lookup'[Sort],9),

IF(

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort],8),

LOOKUPVALUE('Incurred Lookup'[Stratification],'Incurred Lookup'[Sort],8),

IF(

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort],7),

LOOKUPVALUE('Incurred Lookup'[Stratification],'Incurred Lookup'[Sort],7),

IF(

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort],6),

LOOKUPVALUE('Incurred Lookup'[Stratification],'Incurred Lookup'[Sort],6),

IF(

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort],5),

LOOKUPVALUE('Incurred Lookup'[Stratification],'Incurred Lookup'[Sort],5),

IF(

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort],4),

LOOKUPVALUE('Incurred Lookup'[Stratification],'Incurred Lookup'[Sort],4),

IF(

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort],3),

LOOKUPVALUE('Incurred Lookup'[Stratification],'Incurred Lookup'[Sort],3),

IF(

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort],2),

LOOKUPVALUE('Incurred Lookup'[Stratification],'Incurred Lookup'[Sort],2),

LOOKUPVALUE('Incurred Lookup'[Stratification],'Incurred Lookup'[Sort],1) // The first stratification level

))))))))))

===== Sort Formulas ======

Baseline Incurred Stratification Sort =

VAR IncurredAmount = Claim[Baseline Incurred]

VAR StratificationLevel =

SWITCH(

TRUE(),

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort], 11), 11,

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort], 10), 10,

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort], 9), 9,

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort], 8), 8,

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort], 7), 7,

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort], 6), 6,

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort], 5), 5,

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort], 4), 4,

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort], 3), 3,

IncurredAmount >= LOOKUPVALUE('Incurred Lookup'[INC Start], 'Incurred Lookup'[Sort], 2), 2,

1 // Default case if no match

)

RETURN

LOOKUPVALUE('Incurred Lookup'[Sort], 'Incurred Lookup'[Sort], StratificationLevel)

----- Next Formula -------

Net Incurred Stratification Sort =