Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
Hello
It worked, thank you.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |