title: PowerBi Rankx returning only 1 irrespective of category
body: <p>I am trying to get the rank based on the category in powerbi , But not getting the result as expected<a href="https://i.stack.imgur.com/0WoiI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0WoiI.png" alt="enter image description here" /></a>.</p>