TOP 10 Sales for current week

[joshua1990]

I have 3 Tables in the data model that are linked.

The first one is a simple calendar table:

Year-Week	Week Offset
2021-46	-1
2021-47	0

This table shows me in the column [Week Offset] the current week at value '0'.

Then I have an attribute table that shows me the Department for each Article.

Department	Article
AA	A1
BB	B1

And then I have a sales table that shows me sales for each article for each store:

Article	Store	Sales	Year-Week
A1	AA-01	550	2021-47
A1	AA-02	400	2021-47

Now I would like to get a matrix that shows me the TOP 10 Sales overall for the current week:

Article	Store	Sales
A1	AA-01	550
A1	AA-02	400

The TOP 10 sales should consider just the sum on the article level, not on the Store level. But in the matrix, the result should be shown at the store level.

How would you do that?

[amitchandak · Accepted solution]

@joshua1990 , Created a measure like M1 and try to create Rank on that

M1= calculate(sum(Table[sales]), allexcept(Table, Table[Article]))

Rank = rankx(allselected(Table[Article]), [M1],,desc, dense)