Add value of two columns together

[apagan]

I've been attempting to add the value of 2 columns together into one column called Percentage, but have had no success.  Here's the formula I am using:

Percentage = CALCULATE(SUM(Appearances[Winner]) / Appearances[Loser]+Appearance[Winners)

What am I doing wrong?

Thanks!

[JoanCampbell]

I have one column where I added together Up and Built. Now I need to get the percentage up. But it is giving me an error. What am I doing wrong? 

[LaurentCouartou · Accepted solution]

I bet you got an incredibly long error message with a long list of possible reasons why your measure would not work.

This message means you can only reference a column (like Appearances[Loser]😞

- when a row context exists (in the second argument of a FILTER, SUMX, ...., function)

- in an aggregate function like SUM, MIN, MAX, ...

- inside functions like VALUES, ALL, DISTINCT, FILTERS ...

In your case, you probably meant, :

CALCULATE( SUM(Appearances[Winner]) 
 / ( 
     SUM(Appearances[Loser])
      +SUM(Appearance[Winners)
    )
)