Forum Discussion

rogerdea's avatar
rogerdea
Helper IV
5 years ago
Solved

Struggling with RANKX

Hi again   I'm struggling to get a simple rank working, but in addition to this want an additional ranking column to show the rank within another grouping.  My sample pbx is attached, and this is t...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    rogerdea 

    I checked the file, you need to insert the location and the location group from the areas table to the visual:

    You can download the file: HERE

     

    Location Rank = 

RANKX(
    ALLSELECTED(Areas[Location]),
    CALCULATE(SUM(Scores[Score]))
)

--------------------------------------------------------

Overall Rank = 

RANKX(
    ALLSELECTED(Areas[Location],Areas[Location_Group]),
    CALCULATE(SUM(Scores[Score]))
)

    ________________________

    If my answer was helpful, please click Accept it as the solution to help other members find it useful

    Click on the Thumbs-Up icon if you like this reply 🙂


    Website YouTube  LinkedIn