Loading model details...
Mercury 2 | DAXBench
Back to Leaderboard
Inception
Mercury 2
HIGH
Rank
#55
Overview
Analytics
Score Overview
77.2%
Overall Score
76.7%
Accuracy
100.0%
Syntax Valid
Score Dimensions
80
Correctness
79
Best Practices
79
Performance
79
Clarity
Performance by Complexity
Basic
100.0%
Intermediate
78.7%
Advanced
68.0%
Tasks Correct
23 / 30
Avg Response Time
1556ms
Task Breakdown
Summary
Dimensions
Task
Category
Score
Time
Total Sales Amount
task-001
aggregation
100%
639ms
Count of Customers
task-002
aggregation
100%
580ms
Average Unit Price
task-003
aggregation
100%
860ms
Distinct Product Count
task-004
aggregation
100%
489ms
Total Order Quantity
task-005
aggregation
100%
468ms
Year-to-Date Sales
task-006
time intelligence
100%
1060ms
Previous Year Sales
task-007
time intelligence
100%
846ms
Sales by Category Filter
task-008
filtering
100%
943ms
Year-over-Year Growth Percentage
task-009
calculation
100%
2464ms
Running Total with CALCULATE and FILTER
Query Failed
task-010
iterator
10%
2529ms
Sales Summary by Category
task-011
table manipulation
100%
1088ms
Product List with Renamed Columns
task-012
table manipulation
100%
1052ms
Union of High-Value Transactions
task-013
table manipulation
100%
1455ms
Year-Category Analysis Matrix
task-014
table manipulation
100%
1043ms
Product Percentage of Category Total
task-015
context transition
100%
1979ms
Virtual Relationship with TREATAS
Query Failed
task-016
context transition
10%
1631ms
Granularity-Aware Measure with HASONEVALUE
Query Failed
task-017
context transition
10%
2832ms
Running Count with EARLIER
task-018
context transition
30%
1202ms
Multiple Filter Conditions
task-019
filtering
100%
1417ms
Percentage of Total with ALLEXCEPT
task-020
filtering
100%
1313ms
Filter Intersection with KEEPFILTERS
task-021
filtering
100%
2497ms
Product Ranking with RANKX
task-022
iterator
100%
2183ms
Top 5 Products with TOPN
Query Failed
task-023
table manipulation
10%
1975ms
90th Percentile Order Value
task-024
iterator
100%
2840ms
Handle Missing Data with BLANK
task-025
calculation
100%
875ms
Safe Ratio with Cascading Fallbacks
task-026
calculation
100%
1610ms
Safe Year-over-Year with Missing Data
Query Failed
task-027
time intelligence
10%
3396ms
3-Month Rolling Average
Query Failed
task-028
time intelligence
10%
2736ms
Same Month Previous Year Comparison
task-029
time intelligence
100%
1180ms
Fiscal Year-to-Date (July Start)
task-030
time intelligence
100%
1505ms