Forum Discussion

lastnn30's avatar
lastnn30
Icon for Post Patron rankPost Patron
4 years ago
Solved

Finding the max salary

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.

Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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.

2 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    Write these measure

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

     

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    4 years ago

    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.