How to use -1 in a measure

[Anonymous]

Hello, I need to create a calculated  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. 

[Gabry · Accepted solution]

Hello @Anonymous 

why what's your issue? I think you can do the same in dax, like measure= 1- divide(variance, opportunity)

[ramakrishna1257]

Hello @Anonymous 
You can use below one in the creating a Measure
Percentage = 1 - DIVIDE( TableName[Variance], TableName[Opportunity] )

[Anonymous · Accepted solution]

Thank you I really appreciate your reply. It works, of course. 

[Gabry · Accepted solution]

Hello @Anonymous 

why what's your issue? I think you can do the same in dax, like measure= 1- divide(variance, opportunity)

[Anonymous]

Thank you I really appreciate your reply. It works, of course.