Need help to create index when we have multiple columns from multiple tables as a measure

[MJALARI]

i have three tables dimregion, dimchannel and factsales. i need to take multiple columns from these two tables . only one column from fact, that is sales. i want to use here matrix visual. i have 6 columns from dim region and dim channel as rows. and measure as sales as i mentioned. sales order by desc need to create ranking. it worked fine when i use only one column in the table as row defined in matrix. but i have now 5 other columns to keep as row. after drag and drop these columns ranking is not coming correctly.

this is the function i used here Rankx(allselected(dimregion), calculate(Sum(Sales)),,desc,Dense)

DIM CHANNEL

CHANNELID  CHANNELNAME

101                channel1

102                channel2

103                channel3

DIM region

Region ID          region          city    state         country        

101                   southregion   A         S1           C1

102                   north              B          S2          C2

103                   east                C          S3          C3

104                     west               D        S4          C4

Fact sales

Regionid   channelid  sales

101             101               50000

102                102            100000

103             103                150000

103              104                2000

Matrix visual should contain

Channelname , Region   , City ,state, country, sales ,rank

for creating rank i need help

[v-angzheng-msft]

Hi, @MJALARI 

Could you please consdier sharing more details about it or a simple sample file without any sesentive information?

To draw a simple picture to show your expected visual so that i may work out with a workaround.

[MJALARI]

@Greg_Deckler  I have added more details now. please help. 

[Greg_Deckler]

@MJALARI Sample data and such would help greatly. Maybe this will assist:

To *Bleep* with RANKX! - Microsoft Power BI Community