https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-negative-number/m-p/995237#M12449 <P>Hi, I thougt that it was required to add an alternative in the function. Thank you for your reply!</P> Fri, 27 Mar 2020 11:49:27 GMT Anonymous 2020-03-27T11:49:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-negative-number/m-p/993399#M12384 <P>Hi Power BI users,</P><P>&nbsp;</P><P>I would like to divide a negative number. Thus, below in my example I would like to see a column for every row a percentage where I divide&nbsp; e.g. salarycost/profit = -79,91%. I have used the Divide function, but this won't give me the result below. The normal divide / is also not working. Is there an alternative where I could see my percentage negatively back?</P><P>&nbsp;</P><P>Thank you instead.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>Value</TD><TD>Percentage %</TD></TR><TR><TD>Profit</TD><TD>&nbsp;€&nbsp;&nbsp; 584.531</TD><TD>100%</TD></TR><TR><TD>Salary cost</TD><TD>&nbsp;€ -467.074</TD><TD>-79,91%</TD></TR><TR><TD>Result</TD><TD>&nbsp;€&nbsp;&nbsp; 117.457</TD><TD>20,09%</TD></TR></TBODY></TABLE> Thu, 26 Mar 2020 13:28:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-negative-number/m-p/993399#M12384 Anonymous 2020-03-26T13:28:13Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-negative-number/m-p/993439#M12387 <P>Not sure, seems to work for me:</P> <P>&nbsp;</P> <P><img /></P> Thu, 26 Mar 2020 13:42:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-negative-number/m-p/993439#M12387 Greg_Deckler 2020-03-26T13:42:53Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-negative-number/m-p/995237#M12449 <P>Hi, I thougt that it was required to add an alternative in the function. Thank you for your reply!</P> Fri, 27 Mar 2020 11:49:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-negative-number/m-p/995237#M12449 Anonymous 2020-03-27T11:49:27Z