How to look at row in PowerBi Formula Measure

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           ...