DAX how to calculate the performance of the department

[Fistachpl]

Hello I have a cookie company

MonthDepartmentSales

01.01.2023	Center	15
01.01.2023	South	22
01.01.2023	North	32
01.02.2023	Center	11
01.02.2023	South	12
01.02.2023	North	44
01.03.2023	Center	33
01.03.2023	South	21
01.03.2023	North	19

I want to filter it by year and month and:
- calculate sales by all deparments in the selected time period

- calculate the rank of each department by: amount of sold cookies by this department / maximum sold amount of cookies by single department in the selected time period * 5

Example:

In January and February the departments sold:
North: 76
South: 34
Center: 26

Maximum amount sold in this perdiod of time by one is therefore: 76

So calculated ranks of each department should be:
For North: 76/76*5 = 5
For South: 34 / 76 *5 = 2,24
For Center: 26/76*5=1,71

I can't figure out which functions I need to use.

Here is the file if You need it

https://1drv.ms/u/s!AmhVPCf3VN6XiRHGtgwsmUavlgee?e=BaEriZ

Thank You for Your help!

[ThxAlot · Accepted solution]

[Fistachpl]

Hello,

thank You for Your answer. How can I copy these values to another table?