DAX calculator for goal where denominators and numerator increase simultaneously

[darkstaarx]

Hi all, 

I am not sure how to describe this better but it is possible to build a DAX to find "x" in this equation? 

Example:

(20+x)/(55+x)=7/10

Answer should be: 61.6 or 62.

The reason why I want this calculation is because our goal is 70%.

Assuming that we at 20/55=36%, how many more to achieve if numerator and denominators increase simultaneously. The answer should be 62 more to achieve min 70% which is (20+62)/(55+62).

In actual world, there's duration involved but I do not wish to make it more complex for now. 

Thank you in advance! 

[eliasayy]

Hello @darkstaarx if i understood correctly lets say you have a table with the columns: date, number 1, and number 2

You want to first divide number 1 with number 2 if you select the slicer of a date for example and then if this number isnt equal or greater than 0.7, then you want to create this equation.

Unfortunately, dax doesnt support placing unknowns like x and y and solve equations at the moment 

[darkstaarx]

Yes, you are right and thanks for the answer. Is there any alternative way to calculate this. I would accept long solution if that something DAX can offer.

[eliasayy]

In my experience powerbi cant solve those equations, the only solution you can do is to do them manually and add them as a new column to do the calculation but you need a true integer 

[darkstaarx]

Noted, then I will just hold my thought first for this one. Thanks!

[Greg_Deckler]

@darkstaarx Sure, if my algebra serves:

(20 + x) / (55 + x) = .7

.7(55 + x) = 20 + x

.7(55) + .7x - 20 - x = 0

-.3x = -.7(55) + 20

.3x = .7(55) - 20

x = (.7(55) - 20 ) / .3