Adding values in RANKX Function

[MontherKH]

I have Employees table, and I want to create a measure that ranks them by adding the values of Salary and Bonus together then rank them, Salary and Bonus are columns in the table.

I wrote this DAX:

Profit Rank = RANKX('Employee Listing',[Salary (USD)] + [Bonus], , DESC)

and Power BI gives me this error:

The value for 'Salary (USD)' cannot be determined. Either the column doesn't exist, or there is no current row for this column.

[menglaro78]

HI @MontherKH ,

I suggest this:

I think your columns Salary and Bonus are not saved in the same table Employee Listing.

So you can write Sum(Table[Salary USD]) + Sum(Table[Bonus]) in your Rankx expression or create a explicit measure before.

Furthermore i suggest to use ALL(Employee Listing'[Employee])

Profit Rank = RANKX(ALL('Employee Listing'[Employee]),sum('Table'[Salary (USD)]) + sum('Table'[Bonus]), , DESC)

RANKX - DAX Guide

Marco

[MontherKH]

They ARE in the same table, and I tried your formula but it gives all the employees rank 1

[menglaro78]

Are you using the all function?

Profit Rank = RANKX(ALL('Employee Listing'[Employee]),sum('Table'[Salary (USD)]) + sum('Table'[Bonus]), , DESC)

[MahyarTF · Accepted solution]

Hi

Is there some reason you created the Measure instead of the calculated column ?

your code is worked if you use it as a column.

Appreciate your Kudos and please select it if it is helps you