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?dl=0
In the attached file, If I have not includd Project ID in the visual, the rank is working fine, but I want to add Project ID and the Rank should consider RiskScore and ProjectID

Thanks in Advance

  • 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.

3 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super 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]
)

     

  • 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.