DAX measure to rank values that returned in a measure (not a calculated column)

[TRK]

Hi,

I have a measure that is multiplying values of 3 measues (each are each sum of items in that are in 3 different tables):

Age is in "Tombstone table"
Last odometer reading is in "Trip table"

Operating repair costs is in "Expenses table"

Surplus Weighted Value = [Age]*0.3 + [Latest Odometer Reading ]*0.3 + [Operating Repair Costs]*0.4

This returns a value in a table:

I want to create a measure that would create a rank list of 1 to xx from the highest value. that would change as I applied other filters on the page.



I have tried a few options but every row returns a '1'.  Is it possible to do this  - what would the DAX look like?

thanks!

[v-luwang-msft · Accepted solution]

Hi @TRK ,

Since you did not provide a specific data template, you can refer to my model. The following atestmeasure is a measure, filtered according to slicer, rank is sorted according to atestmeasure, return value unchecked data.

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[PaulDBrown]

Something along the lines of:

RANK = RANKX(ALLSELECTED (Table), [Surplus Weighted Values])