What is the behavior of RANKX() when there are tied values and the ‘Dense’ ranking order is specified?

Power BI Hard

Power BI — Hard

What is the behavior of RANKX() when there are tied values and the ‘Dense’ ranking order is specified?

Key points

  • 'Dense' ranking ensures consecutive integers are used for ranks
  • Tied values share the same rank in 'Dense' ranking
  • RANKX() handles ties based on the specified ranking order
  • The 'Dense' parameter affects how ranks are assigned after ties

Ready to go further?

Start full exam Practice more questions

Related questions