How to look at row in PowerBi Formula Measure

[Lattelin]

Hello everyone,

I am trying to make a formula that calculates the percentage of successful sales. I have a table that kind of looks like the following.

Discount %   Sale Closed

20                  Successful

10                   Not Successful

30                   Successful

I am currently trying to make a measure with the following formula:

Measure PercentWin = Calculate('Successful'/Sum('Not Successful'+'Successful'))

I am getting error "cannot find table Successful". Could someone guide me on the correct formula I should use. Thank you very much. 🙂

[Jihwan_Kim · Accepted solution]

https://www.dropbox.com/s/nlq3yct8xcz72xi/lattel.pbix?dl=0