Finding the max salary

[lastnn30]

Hi

I can create a table which shows Dept and Salary, then I can show the max Salary for each dept. After I found the max salary for each dept, can I show the name of person? In excel pivot table if I click on the salary it will open a new sheet and show the record of that person so I would know the name. Can I do that without wrting DAX. Thank you

Thanks you very much.

[v-zhangti · Accepted solution]

Hi, @lastnn30 

It may be that you still need to use DAX in order to accomplish your needs.

Measure:

Max Salary Name =
IF (
    SELECTEDVALUE ( tdEmployee[Salary] )
        = CALCULATE (
            MAX ( tdEmployee[Salary] ),
            FILTER (
                ALL ( tdEmployee ),
                [Department] = SELECTEDVALUE ( tdEmployee[Department] )
            )
        ),
    SELECTEDVALUE ( tdEmployee[Name] )
)

When you click on the highest Salary in each department, the name of the person is displayed.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

Write these measure

Salary paid = sum(tdEmployee[Salary])

Highest salary paid to = FIRSTNONBLANK(TOPN(1,VALUES(tdEmployee[Name]),[Salary paid]),1)