Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I have a table containing Country names and Priority Orders
Country Priority
UK 1
US 1
NL 2
and another table containing a measure that sums a value
What I want is
Rank Priority Country SumofValue
1 1 US 1000
2 2 NL 900
3 1 UK 800
But what I am getting is the following because it's ranking by country within the Priority groups
Rank Priority Country SumofValue
1 1 US 1000
1 2 NL 900
2 1 UK 800
My DAX is al follows
Solved! Go to Solution.
hi @GWoodhouse
try like:
hi @GWoodhouse
try like:
PERFECT!
Now please explain why that works 😉
[MySumMeasure], as a measure, has an implicit CALCULATE, which converts the row context - Priority, to filter context.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
7 | |
5 | |
4 | |
3 |
User | Count |
---|---|
12 | |
12 | |
10 | |
9 | |
9 |