TOP 10 Sales for current week

joshua1990 — Fri, 26 Nov 2021 11:49:59 GMT

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?

Re: TOP 10 Sales for current week

amitchandak — Fri, 26 Nov 2021 17:08:13 GMT

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)

topic Re: TOP 10 Sales for current week in DAX Commands and Tips

TOP 10 Sales for current week

Re: TOP 10 Sales for current week