I have 3 Tables in the data model that are linked.
The first one is a simple calendar table:
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.
And then I have a sales table that shows me sales for each article for each store:
Now I would like to get a matrix that shows me the TOP 10 Sales overall for the current week:
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?
Go to 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)
View solution in original post
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!