Display rank for a specific item

[wenchi]

I am using a score card to display the selected chain rank among the nearby chain by current year volume. I've create two dax meatures to help me validate the outcome.

The actual report won't display the table, just the score card.
The dax for two measures are. It's not working consistantly for all the chains, not sure why. Hope to know what i did wrong. If I set the visual level filter to the score card
with the selected chain_id, it always works. However, i can't do that since the user can pick any chain in this report.

0rank1 = rankx(all(Dim_TA_Store[chain_level1_id]),[Chain TA CY CPW],,DESC,Skip)
0rank2 =
var selchain=SELECTEDVALUE(Dim_Chain[chain_level1_id])
var result=CALCULATE([0rank1],Dim_TA_Store[chain_level1_id]=selchain)
return result

[amitchandak · Accepted solution]

@wenchi , Try like

maxx(filter(values(Dim_TA_Store[chain_level1_id]),Dim_TA_Store[chain_level1_id]=SELECTEDVALUE(Dim_Chain[chain_level1_id])), [0rank1])