Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If ‘Goals Scored’ is less than or equal to 3 I want the expression below to calculate otherwise do nothing
=Sum({$<NumDate= {$(=(Max([NumDate])))}>}[Goals Scored])
Here is my expression that the expression editor says OK for but when I click Apply, it does not work
=IF ([Goals Scored]<=3,), Sum({$<NumDate= {$(=(Max([NumDate])))}>}[Goals Scored])
Here is my data
| Date | Country | Goals Scored |
| 7/15/2018 | France | 4 |
| 7/15/2018 | Croatia | 2 |
| 7/14/2018 | Belgium | 2 |
| 7/14/2018 | England | 0 |
| 7/11/2018 | England | 1 |
| 7/11/2018 | Croatia | 2 |
| 7/10/2018 | France | 1 |
| 7/10/2018 | Belgium | 0 |
| 7/7/2018 | Sweden | 0 |
| 7/7/2018 | England | 2 |
| 7/7/2018 | Russia | 5 |
| 7/7/2018 | Croatia | 6 |
| 7/6/2018 | Uruguay | 0 |
| 7/6/2018 | France | 2 |
| 7/6/2018 | Brazil | 1 |
| 7/6/2018 | Belgium | 2 |
Using the data above my Table chart should look like this …
| Country | Goals Scored |
| Belgium | 4 |
| Brazil | |
| Croatia | 4 |
| England | 3 |
| France | 3 |
| Russia | |
| Sweden | |
| Uruguay |
Can you assist?
Hi,
=IF ([Goals Scored]<=3,), Sum({$<NumDate= {'$(=(Max([NumDate])))'}>}[Goals Scored])
a comma to remove and two simple quotes to add
Hi,
=IF ([Goals Scored]<=3,), Sum({$<NumDate= {'$(=(Max([NumDate])))'}>}[Goals Scored])
a comma to remove and two simple quotes to add