Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I have 3 different master tables linked with some fact tables. All I want to create a Rankx measure, and rank those master tables fields by a specific measure.
My Sales measure works for 3 different fields and shows the results. If I create 3 different Rankx measure for each of those fields, its also working.
They are different table and I m not able to use RANKX(<table>, <expression>, <value>, <order>, <ties>) function.
Any chance to get some help?
Table 1: Gender
Table 2: Age Group
Table 3: Region
Common Measure is Sales and working perfectly for 3 of them
Solved! Go to Solution.
HI @erenonem ,
Pls refer the below:
base table:
Result:
You could download my pbix file to learn detail operations.
Best Regards
Lucien
HI @erenonem ,
Pls refer the below:
base table:
Result:
You could download my pbix file to learn detail operations.
Best Regards
Lucien
Hi
Create a table expression to combine your 3 table (they should same number of columns and column names), then rank it. Try this one
rank =
var table = UNION (table 1, table 2, table 3)
return RANKX([table],value)
User | Count |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |