Expression

[JoseGarcia]

hi there, 

trying to create a measure that calculates: 

=26-If(region = 'CNE', Count(TOTAL <region> overall_score),
36-If(region = 'APAC', Count(TOTAL <region> overall_score),
97-If(region = 'Europe', Sum(TOTAL <region> overall_score))))

but only CNE calculates ok

any ideas?

[MatheusC · Accepted solution]

@JoseGarcia 

see leaving it as:

=
If(region = 'CNE',
       26-Count(TOTAL <region> overall_score),
If(region = 'APAC',
       36- Count(TOTAL <region> overall_score),
If(region = 'Europe',
        97-Sum(TOTAL <region> overall_score)

)))


- Matheus