Understanding of row context in detail with this example

[Anonymous]

I am trying to create the below calculated column to understand the row context in detail. 

Here I am trying to rank net value. The var net_value is used to get the current row in the table and var max_value is used to get list of all the rows greated than the currect net value and count rows in the end.

But this formula is giving blank return, Can anyone explain whats the error in the below formula.

Rank PO ITem =

var net_value = 'Table'[  Net value]

var max_value =

        FILTER(Table,

        'Table'[  Net value] > net_value

        )  

RETURN COUNTROWS(max_value)

[tamerj1 · Accepted solution]

@Anonymous 

Nothing wrong. It should work. Double check that you are creating a calculated column in the same table that is referenced inside FILTER function