Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! 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)
@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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |