Why is this expression not working?

[#1]

I have the following expression.

if([RecordType] <> 'ExPL' OR [RecordType] <> 'ExDE' OR [RecordType] <> 'ExFR',

if(Sum({<[CustomerKey]-={'106180' , '104300','105680' , '305000'  , '305500'  ,'51062'  , '50339', '10339', '11678', '101230'}>} [InvoiceNetValue]) > 1000000,
Num(Sum({<[CustomerKey]-={'106180' , '104300','105680' , '305000'  , '305500'  ,'51062'  , '50339', '10339', '11678', '101230'}>} [InvoiceNetValue])/1000,'#.##0M;-#.##0M'),
Num(Sum({<[CustomerKey]-={'106180' , '104300','105680' , '305000'  , '305500'  ,'51062'  , '50339', '10339', '11678', '101230'}>} [InvoiceNetValue])/1000,'#.##0K;-#.##0K'))

,0)

First I want to make sure these 3 record types are excluded. Then I want to exclude the selected CustomerKeys.

The middle part works. the right customers are excluded. But whe I add the [RecordType] filter the result stays the same.

[CELAMBARASAN · Accepted solution]

try with this

if(Sum({<[CustomerKey]-={'106180' , '104300','105680' , '305000'  , '305500'  ,'51062'  , '50339', '10339', '11678', '101230'}, [RecordType] -={'ExPL', 'ExDE', 'ExFR'}>} [InvoiceNetValue]) > 1000000, 

Num(Sum({<[CustomerKey]-={'106180' , '104300','105680' , '305000'  , '305500'  ,'51062'  , '50339', '10339', '11678', '101230'},[RecordType] -={'ExPL', 'ExDE', 'ExFR'}>} [InvoiceNetValue])/1000,'#.##0M;-#.##0M'), 

Num(Sum({<[CustomerKey]-={'106180' , '104300','105680' , '305000'  , '305500'  ,'51062'  , '50339', '10339', '11678', '101230'},[RecordType] -={'ExPL', 'ExDE', 'ExFR'}>} [InvoiceNetValue])/1000,'#.##0K;-#.##0K'))

Celambarasan

[#3]

Worked perfectly. Thanks mate!