Forum Discussion

vally57's avatar
vally57
Icon for Helper I rankHelper I
3 years ago
Solved

Rank based on two columns

Hi Experts, I want to create Rank based on two columns. I have tried for creating Rank on single column, but for it is not working as expected. https://www.dropbox.com/s/3ec0qxc2avt0t95/Rank.pbix...
  • v-xiaotang's avatar
    v-xiaotang
    3 years ago

    Hi vally57 

    Thanks for reaching out to us.

    you can try this measure to add project id

    project id = MAXX(FILTER(Project,Project[ProjectKey]=MIN('Fact Risk'[ProjectKey])),[Project ID])

     

     

    Best Regards,

    Community Support Team _Tang

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

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

 

 

 

RISK - Ranking Fix =
RANKX (
    SUMMARIZE (
        ALLSELECTED ( 'Fact Risk' ),
        'Risk'[Risk Name],
        Project[Project ID]
    ),
    [Risk - NetRiskRating]
)