pbiexpert
/
DAXQuest
Learn
Cockpit
Practice
Roadmap
Projects
DAX Dictionary
Diagnostic
Profile
Tools
1 day
L1
DAX Novice
(0 XP)
Sign In / Sync
Sync
Health Check
Challenges
Count High Volume Transactions with COUNTX
intermediate
DAX Reference
+100 XP
1 day
Brief & Visual
Formula Studio
Model Fields
Concept:
COUNTX
Objective
Use COUNTX over Sales to count rows where Quantity is at least 3.
Illustrative visual preview
Card KPI
Visual Slice
Filters
Filter Context:
π Year = 2025
π Country = All
π·οΈ Segment = All
Count High Volume Transactions with COUNTX
β β β
Awaiting valid DAX formula check
Guided Hints
0 of 1 revealed
Show Hint 1
Stuck? Reveal canonical solution
fx
[fx]
High Quantity Orders
=
Format DAX
Check formula
Loading DAX Formula Studio...
Switch to simple editor
Ctrl+Enter
Check
β’
Ctrl+Shift+F
Format
β’
Type [ for fields
Plain
Model
Fields
Diagram
Data
[fx]
Measures
10
[fx]
Total Revenue
[fx]
Total Cost
[fx]
Total Profit
[fx]
Profit Margin %
[fx]
Total Quantity
[fx]
Total Orders
[fx]
Customer Count
[fx]
Average Order Value
[fx]
Previous Year Revenue
[fx]
YoY Revenue Growth %
Sales
Fact
β’
7
π
SaleID
π
Date
π
CustomerID
π
ProductID
β
Quantity
β
Revenue
β
Cost
Customers
Dim
β’
4
π
CustomerID
Aa
CustomerName
Aa
Country
Aa
Segment
Products
Dim
β’
4
Date
Dim
β’
5
Click field to copy syntax
DAX Active