Forum Discussion

Lattelin's avatar
Lattelin
Frequent Visitor
5 years ago
Solved

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                  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. 🙂
 
Need Help