cancel
Showing results for
Did you mean:
Post Prodigy

## TOP 10 Sales for current week

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?

1 ACCEPTED SOLUTION
Super User

@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)

Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
Super User

@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)

Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Announcements