calculate totals but filter out a specific product

[Alxnder]

Hello all,

Been trying to figure this out for a couple of hours. Pretty much new to DAX!
Any help would be appreciated!!

Here is sample data set. I want to sum all qty except for the domestic market.
The return should look like this - Export market - 406 . 

Item Type	Description	Export Market	Qty
FGL	CA Navel Standard Carton PCA Fancy 072 New Zealand HP 63 cpp	New Zealand	27
FGL	CA Navel Standard Carton PCA Fancy 072 New Zealand HP 63 cpp	New Zealand	9
FGL	CA Navel Standard Carton PCA Fancy 056 New Zealand HP 63 cpp	New Zealand	6
FGL	CA Navel Standard Carton PCA Fancy 088 New Zealand HP 63 cpp	New Zealand	7
FGL	CA Navel Standard Carton ULTIM ST Choice 138 Domestic RP 54 cpp	Domestic	8
FGL	CA Navel Euro Standard Carton KASHU HBX Fancy 048 Korea HP 50 cpp	Korea	22
FGL	CA Navel Euro Standard Carton KASHU HBX Fancy 056 Korea HP 50 cpp	Korea	50
FGL	CA Navel Euro Standard Carton KASHU HBX Fancy 056 Korea HP 50 cpp	Korea	50
FGL	CA Navel Euro Standard Carton KASHU HBX Fancy 056 Korea HP 50 cpp	Korea	50
FGL	CA Navel Euro Standard Carton KASHU HBX Fancy 056 Korea HP 50 cpp	Korea	50
FGL	CA Navel Euro Standard Carton KASHU HBX Fancy 056 Korea HP 50 cpp	Domestic	50
FGL	CA Navel Euro Standard Carton KASHU HBX Fancy 056 Korea HP 50 cpp	Korea	50
FGL	CA Navel Euro Standard Carton KASHU HBX Fancy 056 Korea HP 50 cpp	Korea	40
FGL	CA Navel Euro Standard Carton KASHU HBX Fancy 056 Korea HP 50 cpp	Korea	45
FGL	CA Navel Euro Standard Carton KASHU HBX Fancy 056 Korea HP 50 cpp	Domestic	40

[adudani · Accepted solution]

hi @Alxnder ,
create a measure shown below:

output

[Alxnder]

Wow, first of all, thanks for the really quick response. Secondly, it worked like a charm, much appreciated!!