Forum Discussion

kulpowerbi's avatar
kulpowerbi
Icon for Helper I rankHelper I
5 years ago
Solved

Rank for Hierarchy in Matrix visual not working

I am looking for solultion that find ranking even when we have Hirarchy. But on my method ranking is only working for one category in matrix, rest are showing rank as one onlye. Attached please see t...
Need Help
Show and Tell
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    5 years ago

    kulpowerbi , Thanks for sharing the file. Please try a formula like

    %To GoalRank_Ofc = RANKX(FILTER(ALLSELECTED(Clinics[Office],Clinics[Region]),Clinics[Region] =max(Clinics[Region])),[%To Goal],,DESC,Dense)
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

kulpowerbi , Thanks for sharing the file. Please try a formula like

%To GoalRank_Ofc = RANKX(FILTER(ALLSELECTED(Clinics[Office],Clinics[Region]),Clinics[Region] =max(Clinics[Region])),[%To Goal],,DESC,Dense)