BasicAggregationtask-001
Total Sales Amount
Create a measure that calculates the total net sales from the Sales table.
measuresumbasic-aggregationcontoso
Task Context
Create a DAX measure called 'Total Sales' that calculates the sum of the 'Net Price' column from the 'Sales' table.
Expected Output
1
Total Sales = SUM(Sales[Net Price])
+ 2 alternative correct answers
Model Results
89 correct93 models
Model
Score
Status
Olmo 3 32B Think (free)
AllenAI
100%
Nova 2 Lite (free)
Amazon
100%
Nova Micro 1.0
Amazon
100%
Nova Premier 1.0
Amazon
100%
Claude 3 Haiku
Anthropic
100%
Claude 3.5 Haiku
Anthropic
100%
Claude 3.7 Sonnet
Anthropic
100%
Claude Haiku 4.5
Anthropic
100%
Claude Opus 4.5
Anthropic
100%
Claude Opus 4.6
Anthropic
100%
Claude Sonnet 4
Anthropic
100%
Claude Sonnet 4.5
Anthropic
100%
Claude Sonnet 4.6MED
Anthropic
100%
ERNIE 4.5 VL 424B A47B
Baidu
100%
Seed-2.0-MiniMED
ByteDance Seed
100%
DeepSeek V3 0324
DeepSeek
100%
DeepSeek V3.1
DeepSeek
100%
R1
DeepSeek
100%
R1 0528
DeepSeek
100%
DeepSeek V3.2
DeepSeek
100%
DeepSeek V3.2 Speciale
DeepSeek
100%
Gemini 2.0 Flash
Google
100%
Gemini 2.0 Flash Experimental (free)
Google
100%
Gemini 2.0 Flash Lite
Google
100%
Gemini 2.5 Flash
Google
100%
Gemini 2.5 Flash Lite Preview 09-2025
Google
100%
Gemini 2.5 Flash Preview 09-2025
Google
100%
Gemini 2.5 Pro
Google
100%
Gemini 3 Flash Preview
Google
100%
Gemini 3 Pro Preview
Google
100%
Gemini 3.1 Flash Lite PreviewHIGH
Google
100%
Gemini 3.1 Pro PreviewHIGH
Google
100%
Gemma 3 27B (free)
Google
100%
Mercury 2HIGH
Inception
100%
KAT-Coder-Pro V1 (free)
Kwaipilot
100%
LFM2-24B-A2B
Liquid
100%
Llama 3.3 70B Instruct
Meta
100%
Llama 4 Maverick
Meta
100%
Phi 4
Microsoft
100%
MiniMax M2
Minimax
100%
Devstral 2 2512 (free)
Mistral
100%
Mistral Large 3 2512
Mistral
100%
Mistral Small 3.1 24B
Mistral
100%
Kimi K2 Thinking
Moonshot AI
100%
Kimi K2.5
Moonshot AI
100%
DeepSeek V3.1 Nex N1 (free)
Nex AGI
100%
Nemotron 3 Nano 30b A3b (free)
Nvidia
100%
Nemotron 3 Super (free)
Nvidia
100%
GPT-3.5 Turbo
OpenAI
100%
GPT-4.1 Mini
OpenAI
100%
GPT-4o (2024-11-20)
OpenAI
100%
GPT-4o-mini
OpenAI
100%
GPT-4o-mini (2024-07-18)
OpenAI
100%
GPT-5 Mini
OpenAI
100%
GPT-5 Nano
OpenAI
100%
GPT-5.1
OpenAI
100%
GPT-5.1-Codex-Max
OpenAI
100%
GPT-5.1-Codex-Mini
OpenAI
100%
GPT-5.2
OpenAI
100%
GPT-5.2 Chat
OpenAI
100%
GPT-5.3 Chat
OpenAI
100%
GPT-5.3-CodexHIGH
OpenAI
100%
GPT-5.4HIGH
OpenAI
100%
gpt-oss-120b
OpenAI
100%
gpt-oss-20b (free)
OpenAI
100%
o3
OpenAI
100%
o4 Mini
OpenAI
100%
Aurora Alpha
Openrouter
100%
Hunter Alpha
Openrouter
100%
Sonar Reasoning Pro
Perplexity
100%
Qwen3 Coder Next
Qwen
100%
Qwen3 Coder 480B A35B (free)
Qwen
100%
Qwen3 Max Thinking
Qwen
100%
Qwen3.5-122B-A10BMED
Qwen
100%
Qwen3.5-27BMED
Qwen
100%
Qwen3.5-35B-A3B
Qwen
100%
Qwen3.5 397B A17B
Qwen
100%
Qwen3.5-FlashMED
Qwen
100%
Qwen3.5 Plus 2026-02-15MED
Qwen
100%
DeepSeek R1T2 Chimera (free)
TNG
100%
Palmyra X5
Writer
100%
Grok 3 Mini
xAI
100%
Grok 4
xAI
100%
Grok Code Fast 1
xAI
100%
MiMo-V2-Flash (free)
Xiaomi
100%
GLM 4.5 Air (free)
Z.AI
100%
GLM 4.7
Z.AI
100%
GLM 4.7 Flash
Z.AI
100%
GLM 5
Z.AI
100%
LFM2.5-1.2B-Instruct (free)
Liquid
10%
LFM2.5-1.2B-Thinking (free)
Liquid
10%
Llama 3.2 1B Instruct
Meta
10%
Mistral Small 3.2 24B
Mistral
0%
Success Rate
96%
of models solved correctly
0%100%
89 correct
3 partial
1 failed