Ranking Bid Submission

Anonymous,

Wrap the <Expression> in RANKX within a CALCULATE statement.

I think i got it.

TestAll-Inclusive FEU rate (40' Dry, No Bunker) - Port to Port = if('Carrier Master'[Carrier Name] = "Test Supplier",'Carrier Master'[All-Inclusive FEU rate (40' Dry, No Bunker) - Port to Port] +1,'Carrier Master'[All-Inclusive FEU rate (40' Dry, No Bunker) - Port to Port])

above is the corrected formula but below is the help i got.

I found that the value (of All-Inclusive FEU rate (40' Dry, No Bunker) - Port to Port) was same for each supplier within a Lane number. That was the reason you were getting 1 Rank. So 2 things we have to do add one measure and modify the rankx formula

1. Create a measure column which will be Total on 'Carrier Master'[All-Inclusive FEU rate (40' Dry, No Bunker) - Port to Port]) .

Say for example

TotalAll-Inclusive FEU rate (40' Dry, No Bunker) - Port to Port  = sum('Carrier Master'[All-Inclusive FEU rate (40' Dry, No Bunker) - Port to Port])

1. Remember Rankx is an iterator and we want to run only on suppliers.

Rank Suplier with in Lane# = if(isblank('Carrier Master'[TotalAll-Inclusive FEU rate (40' Dry, No Bunker) - Port to Port]),BLANK(),   RANKX(Filter(All('Carrier Master'[Carrier Name]), Not(ISBLANK([TotalAll-Inclusive FEU rate (40' Dry, No Bunker) - Port to Port]))), [TotalAll-Inclusive FEU rate (40' Dry, No Bunker) - Port to Port],,ASC))

In the attached file I added TestAll-Inclusive FEU rate (40' Dry, No Bunker) - Port to Port (for testing purpose as the values were same for each suppliers), Second thing I added TotalRate Measure (similar to #1) and third thing I did is added Rank Suplier with in Lane#(Similar to #2).