topic How to use -1 in a measure in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-1-in-a-measure/m-p/4076297#M161855 <P>Hello, I need to create a calculated&nbsp; percentage by using a formula that would allow me to do = 1-(variance/opportunity) I know this is an Excel formula but I need to find a DAX equivalent.&nbsp;</P> Fri, 02 Aug 2024 15:12:07 GMT Anonymous 2024-08-02T15:12:07Z How to use -1 in a measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-1-in-a-measure/m-p/4076297#M161855 <P>Hello, I need to create a calculated&nbsp; percentage by using a formula that would allow me to do = 1-(variance/opportunity) I know this is an Excel formula but I need to find a DAX equivalent.&nbsp;</P> Fri, 02 Aug 2024 15:12:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-1-in-a-measure/m-p/4076297#M161855 Anonymous 2024-08-02T15:12:07Z Re: How to use -1 in a measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-1-in-a-measure/m-p/4076352#M161861 <P>Hello&nbsp;Anonymous</LI-USER>&nbsp;</P> <P>why what's your issue? I think you can do the same in dax, like measure= 1- divide(variance, opportunity)</P> Fri, 02 Aug 2024 15:36:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-1-in-a-measure/m-p/4076352#M161861 Gabry 2024-08-02T15:36:17Z Re: How to use -1 in a measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-1-in-a-measure/m-p/4076380#M161862 <P>Hello&nbsp;Anonymous</LI-USER>&nbsp;<BR />You can use below one in the creating a Measure<BR /><STRONG>Percentage = 1 - DIVIDE( TableName[Variance], TableName[Opportunity] )</STRONG></P> Fri, 02 Aug 2024 15:51:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-1-in-a-measure/m-p/4076380#M161862 ramakrishna1257 2024-08-02T15:51:27Z Re: How to use -1 in a measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-1-in-a-measure/m-p/4076489#M161865 <P>Thank you I really appreciate your reply. It works, of course.&nbsp;</P> Fri, 02 Aug 2024 16:52:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-1-in-a-measure/m-p/4076489#M161865 Anonymous 2024-08-02T16:52:40Z Re: How to use -1 in a measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-1-in-a-measure/m-p/4076493#M161866 Thank you I really appreciate your reply. It works, of course.&nbsp; Fri, 02 Aug 2024 16:53:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-use-1-in-a-measure/m-p/4076493#M161866 Anonymous 2024-08-02T16:53:25Z