RANKX Always Returns 1

[amilecki]

I am trying to learn the RANKX expression using a couple examples on the web but every row returns 1.  I have found a couple suggested solutions, none of which have worked for me.

I have simplified my data set to just 3 rows in a <name, value> table as follows:

Name   Value

A          3

B          1

C          2

I create a new measure as:

Total = SUM(MyData[Value]) 

Then create a new column as:

MyRank = RANKX(ALL(MyData[Name]), [Total]) 

I have tried ALL(MyData) and ALL(MyData[Value]) as the first argument with no luck.  I have also tried computing the sum within the second argument both with and without CALCULATE, again no luck.

MyRank = RANKX(ALL(MyData[Value]), CALCULATE(SUM(MyData[Value])))

I don't know how I can possibly make this example simpler and I've exhausted all my research on this.  Please help.