Forum Discussion

vally57's avatar
vally57
Helper 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.

v-xiaotang's avatar
v-xiaotang
Community Support
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.