topic Re: DAX how to calculate the performance of the department in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-how-to-calculate-the-performance-of-the-department/m-p/3192167#M115787 <P><img /></P> Mon, 17 Apr 2023 19:31:09 GMT ThxAlot 2023-04-17T19:31:09Z DAX how to calculate the performance of the department https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-how-to-calculate-the-performance-of-the-department/m-p/3192010#M115777 <P>Hello I have a cookie company</P><P>&nbsp;</P><P>MonthDepartmentSales</P><TABLE><TBODY><TR><TD>01.01.2023</TD><TD>Center</TD><TD>15</TD></TR><TR><TD>01.01.2023</TD><TD>South</TD><TD>22</TD></TR><TR><TD>01.01.2023</TD><TD>North</TD><TD>32</TD></TR><TR><TD>01.02.2023</TD><TD>Center</TD><TD>11</TD></TR><TR><TD>01.02.2023</TD><TD>South</TD><TD>12</TD></TR><TR><TD>01.02.2023</TD><TD>North</TD><TD>44</TD></TR><TR><TD>01.03.2023</TD><TD>Center</TD><TD>33</TD></TR><TR><TD>01.03.2023</TD><TD>South</TD><TD>21</TD></TR><TR><TD>01.03.2023</TD><TD>North</TD><TD>19</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to filter it by year and month and:<BR />- calculate sales by all deparments in the selected time period</P><P>- calculate the rank of each department by:&nbsp;<STRONG>amount of sold cookies by this department / maximum sold amount of cookies by single department in the selected time period * 5<BR /><BR /></STRONG>Example:<BR /><BR /></P><P>In January and February the departments sold:<BR />North: 76<BR />South: 34<BR />Center: 26</P><P>Maximum amount sold in this perdiod of time by one is therefore: 76<BR /><BR />So calculated ranks of each department should be:<BR />For North: 76/76*5 = 5<BR />For South: 34 / 76 *5 = 2,24<BR />For Center: 26/76*5=1,71</P><P>&nbsp;</P><P>I can't figure out which functions I need to use.</P><P>&nbsp;</P><P>Here is the file if You need it</P><P><A href="https://1drv.ms/u/s!AmhVPCf3VN6XiRHGtgwsmUavlgee?e=BaEriZ" target="_blank" rel="noopener">https://1drv.ms/u/s!AmhVPCf3VN6XiRHGtgwsmUavlgee?e=BaEriZ</A></P><P>&nbsp;</P><P>Thank You for Your help!</P> Mon, 17 Apr 2023 16:45:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-how-to-calculate-the-performance-of-the-department/m-p/3192010#M115777 Fistachpl 2023-04-17T16:45:52Z Re: DAX how to calculate the performance of the department https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-how-to-calculate-the-performance-of-the-department/m-p/3192167#M115787 <P><img /></P> Mon, 17 Apr 2023 19:31:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-how-to-calculate-the-performance-of-the-department/m-p/3192167#M115787 ThxAlot 2023-04-17T19:31:09Z Re: DAX how to calculate the performance of the department https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-how-to-calculate-the-performance-of-the-department/m-p/3257939#M120378 <P>Hello,</P><P>&nbsp;</P><P>thank You for Your answer. How can I copy these values to another table?</P> Mon, 29 May 2023 12:07:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-how-to-calculate-the-performance-of-the-department/m-p/3257939#M120378 Fistachpl 2023-05-29T12:07:41Z