topic Rank based on two columns in DAX Commands and Tips

Rank based on two columns

vally57 — Fri, 30 Sep 2022 17:30:06 GMT

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

Re: Rank based on two columns

amitchandak — Sat, 01 Oct 2022 02:25:10 GMT

vally57 , Refer my video on the same

Power BI Rank Across dimension tables: https://youtu.be/X59qp5gfQoA

Re: Rank based on two columns

Jihwan_Kim — Sat, 01 Oct 2022 04:22:25 GMT

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] )

Re: Rank based on two columns

v-xiaotang — Mon, 03 Oct 2022 09:56:39 GMT

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.