RANKX based on fact and dimesion table

[andy1884]

Apologies in advance for a seemingly stupid question - I've only just started (1 day) with Power BI having previously used Cognos Analytics.

Simple case - I have a dimension table for stores which has an Area Manager on it. I then have a fact table with summary sales by store by week. Both are joined with a relationship pon the Store ID

What I want is a ranked list of Area Managers based on the Gross Sales. The list works fine, but adding a Rankx just shows all 1.

The command I'm using is 

RankofGross = rankx(allselected(Dim Table[AreaManager]),calculate(SUM(Fact Table[GrossValue])))

I've seen lots of posts with variations of this command with all, allselected and nothing at all and also RELATED, so I'm a little lost - any help appreciated, must be a simple fix, right?

[andy1884]

can't be that hard can it ?

In the model below, I would want to rank Name (from Customers) by sales value (from Sales).

Am I missig something fundamental like all data has to be on a single query for it work.

[andy1884 · Accepted solution]

sorted...needs to be a measure column