Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
10 | |
10 | |
9 | |
6 |