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 2 columns from two different tables as below:
Table1:
size |
1 |
2 |
3 |
4 |
Table2:
unit |
50 |
49 |
48 |
47 |
Desired Output:(New Calculated Table)
size | unit |
1 | 50 |
2 | 50 |
2 | 49 |
3 | 50 |
3 | 49 |
3 | 48 |
4 | 50 |
4 | 49 |
4 | 48 |
4 | 47 |
So based on size value(number) from the Table1, the top values should return in new rows for example: if size value is 3 then top 3 values, if it is 4 then top 4 values and so on..
Can somebody please help on how can i achieve this in DAX?
Solved! Go to Solution.
Here's my attempt:
New Table =
var crossjoined = CROSSJOIN(unit, size)
var toReturn = FILTER(crossjoined, [size] >= RANK(unit, ORDERBY([unit], DESC)))
return toReturn
Here's my attempt:
New Table =
var crossjoined = CROSSJOIN(unit, size)
var toReturn = FILTER(crossjoined, [size] >= RANK(unit, ORDERBY([unit], DESC)))
return toReturn
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |