https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-in-calculating-employee-bonuses/m-p/3373520#M126988 <P>please provide with more explaiantion this is not clear of what you want how is your percentage calculated? how is your orders calculated?<BR /><BR />this is what i got but different from your reults<BR /><BR /></P><P><img /></P><P>&nbsp;</P><P><BR /><BR /><BR /></P> Thu, 10 Aug 2023 06:55:21 GMT eliasayyy 2023-08-10T06:55:21Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-in-calculating-employee-bonuses/m-p/3372577#M126943 <P><SPAN>Hi I need help with creating two measures to calculate employee bonuses.</SPAN></P><P>&nbsp;</P><P><SPAN class=""><SPAN class="">I have such a report and I would like to calculate two measures in the lower table:</SPAN></SPAN></P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P><SPAN class=""><SPAN class="">The first measure "Percentage of orders from category 1" - it is supposed to tell what percentage of all orders of a given employee are orders from category 1</SPAN></SPAN></P><P>&nbsp;</P><P><SPAN class=""><SPAN class="">The second measure: "Bonus" - for each order, if for a given agent, the percentage of orders from the first category is greater than 50%, then the bonus for the order is 20, and if it is below, 10</SPAN></SPAN></P><P>&nbsp;</P><P><SPAN>Here is what the result table should look like:</SPAN></P><TABLE><TBODY><TR><TD>Order ID</TD><TD>order_date</TD><TD>seller&nbsp;</TD><TD>category</TD><TD>Percentage of orders from category 1</TD><TD>Bouns&nbsp;</TD></TR><TR><TD>1</TD><TD>01.07.2023</TD><TD>A</TD><TD>cattergory 1</TD><TD>25%</TD><TD>10</TD></TR><TR><TD>2</TD><TD>01.07.2023</TD><TD>A</TD><TD>cattergory 2</TD><TD>25%</TD><TD>10</TD></TR><TR><TD>3</TD><TD>04.07.2023</TD><TD>B</TD><TD>cattergory 1</TD><TD>100%</TD><TD>20</TD></TR><TR><TD>4</TD><TD>05.07.2023</TD><TD>C</TD><TD>cattergory 2</TD><TD>0%</TD><TD>10</TD></TR><TR><TD>5</TD><TD>07.07.2023</TD><TD>B</TD><TD>cattergory 1</TD><TD>100%</TD><TD>20</TD></TR><TR><TD>6</TD><TD>07.07.2023</TD><TD>A</TD><TD>cattergory 2</TD><TD>25%</TD><TD>10</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>Source data:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Order ID</TD><TD>order_date</TD><TD>seller&nbsp;</TD><TD>category</TD></TR><TR><TD>1</TD><TD>01.07.2023</TD><TD>A</TD><TD>cattergory 1</TD></TR><TR><TD>2</TD><TD>01.07.2023</TD><TD>A</TD><TD>cattergory 2</TD></TR><TR><TD>3</TD><TD>04.07.2023</TD><TD>B</TD><TD>cattergory 1</TD></TR><TR><TD>4</TD><TD>05.07.2023</TD><TD>C</TD><TD>cattergory 2</TD></TR><TR><TD>5</TD><TD>07.07.2023</TD><TD>B</TD><TD>cattergory 1</TD></TR><TR><TD>6</TD><TD>07.07.2023</TD><TD>A</TD><TD>cattergory 2</TD></TR><TR><TD>7</TD><TD>08.07.2023</TD><TD>C</TD><TD>cattergory 1</TD></TR><TR><TD>8</TD><TD>15.08.2023</TD><TD>C</TD><TD>cattergory 2</TD></TR><TR><TD>9</TD><TD>16.08.2023</TD><TD>C</TD><TD>cattergory 1</TD></TR><TR><TD>10</TD><TD>17.08.2023</TD><TD>C</TD><TD>cattergory 2</TD></TR></TBODY></TABLE><P>&nbsp;</P><DIV class=""><SPAN class=""><SPAN class=""><SPAN class="">I am asking for help because I cannot write these measures in such a way that they take into account the possibility of filtering by date and seller slicers.</SPAN></SPAN></SPAN></DIV><DIV class="">&nbsp;</DIV> Thu, 10 Aug 2023 05:46:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-in-calculating-employee-bonuses/m-p/3372577#M126943 Anonymous 2023-08-10T05:46:35Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-in-calculating-employee-bonuses/m-p/3373520#M126988 <P>please provide with more explaiantion this is not clear of what you want how is your percentage calculated? how is your orders calculated?<BR /><BR />this is what i got but different from your reults<BR /><BR /></P><P><img /></P><P>&nbsp;</P><P><BR /><BR /><BR /></P> Thu, 10 Aug 2023 06:55:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-in-calculating-employee-bonuses/m-p/3373520#M126988 eliasayyy 2023-08-10T06:55:21Z