How to create Rankx mesaure using 1 measure and more than 1 table?

[erenonem]

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

[v-luwang-msft · Accepted solution]

HI @erenonem ,

Pls refer the below:

base table:

Result:

You could download my pbix file to learn detail operations.

Best Regards

Lucien

[HoangHugo]

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)