Understanding of row context in detail with this example

Anonymous — Sun, 02 Apr 2023 15:04:19 GMT

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)

Re: Understanding of row context in detail with this example

tamerj1 — Sun, 02 Apr 2023 15:43:03 GMT

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

topic Re: Understanding of row context in detail with this example in DAX Commands and Tips

Understanding of row context in detail with this example

Re: Understanding of row context in detail with this example