Forum Discussion

sizi's avatar
sizi
Icon for Helper II rankHelper II
2 years ago

DAX to define Overall rank based on 2different Ranks

Hello All,   I need to define rank for each employee based on average of 2 defined ranks.   Below is the original data: Employee TaskRank SLA Avg(Task+SLA) John 2 3 2.5 claire 4 ...
Need Help
sizi's avatar
sizi
Icon for Helper II rankHelper II
2 years ago

It showing 1 for all the employees.

 

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
2 years ago

sizi 

Use this measure:

Rank BA Avg = 
IF(
    ISINSCOPE( Table35[Employee]),
    RANKX( 
        ADDCOLUMNS( ALL(Table35) , "Avg" , [BA Avg] ),
        [BA Avg],,
        ASC,
        Dense
    )
)