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)
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi kulpowerbi ,

 

Based on your description, you can create a measure as follows.

Measure =

var x1=RANKX(ALL('Table'[Region]),CALCULATE(SUM('Table'[%-Goal])),,DESC)

var x2=RANKX(FILTER(ALL('Table'[Office],'Table'[Region]),[Region]=MAX('Table'[Region])),CALCULATE(SUM('Table'[%-Goal])),,DESC)

return

IF(HASONEVALUE('Table'[%-Goal]),x2,x1)

 

Result:

 

 

Hope that's what you were looking for.

Best Regards,

Yuna

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Thank you Anonymous for posting the solution, I will try out this way and revert back.