Sum goals scored exclude country

brucemeyers — Fri, 07 Sep 2018 01:48:29 GMT

Greetings Giovanne Bergstein,

I want to modify your expression

Sum({$<NumDate= {$(=(Max([NumDate])))}>}[Goals Scored])

To exclude England, here is my attempt

IF([Country] <> ‘England’, Sum({$<NumDate= {$(=(Max([NumDate])))}>}[Goals Scored])

The expression editor indicates the expression is ‘OK’ but it blanks out the table values after I click Apply

I want the modified expression to produce this table

Notice England has 0 Goals Scored instead of 3 as it would with your original expression

Here is my data

Can you help?

Re: Sum goals scored exclude country

PrashantSangle — Fri, 07 Sep 2018 03:23:31 GMT

try below

Sum({$<country-={'England'},NumDate= {$(=(Max([NumDate])))}>}[Goals Scored])

Regards,