Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to Solution.
hi @Alxnder ,
create a measure shown below:
output
hi @Alxnder ,
create a measure shown below:
output
Wow, first of all, thanks for the really quick response. Secondly, it worked like a charm, much appreciated!!
User | Count |
---|---|
58 | |
21 | |
18 | |
16 | |
12 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |