Error in calculation to return larger value of a column

[strikw]

Hello,

I'm having a problem calculating a result. I need to return values greater than the field "Valor Apostado", but there is no way I can call this column direct in the formula. And when I take the somatatory from this field gives this error:

The function 'CALCULATE' has been used in a True / False expression that is used as a table filter expression. This is not allowed.

.Jogos Ganhos = Calculate ( Count (Tips[Resultado]); Tips [Resultado] > Tips[.Total Apostado])

Currently the formula is as follows:

.Jogos Ganhos = Calculate ( Count (Tips[Resultado]); Tips [Resultado] > 1)

I need to remove this "1" and put the table column Tips[Valor Aposta] 

I do not know how to do. If anyone can help me.

Thank you.

[v-juanli-msft · Accepted solution]

Hi

Error occurs in your formula due to grammar error.

try this formula 

Jogos Ganhos = CALCULATE(COUNT(Sheet1[Resultado]),FILTER(Sheet1,[Resultado]>[Valor Aposta]))

Best Regards

Maggie

[strikw]

Hello

It worked, thank you.