Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
36 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
30 | |
28 | |
24 | |
22 |