How to show rank of a column based on metric used in another chart.

[Sreya]

Chart1 (Having filter on client)

Products	Revenue	Rank
Product4	9000000	1
Product3	8000000	2
Product1	4000000	3
Product5	2000000	4
Product7	700000	5

Chart2	(Having Filter on Industry)
Products	Revenue	Rank
Product1	100000000	3
Product4	90000000	1
Product8	80000000
Product9	70000000
Product5	60000000	4

Suppose these are the charts, Chart1 is having Products and ranks, ranks have been calculated based on Revenue metric.
Now I am having another chart2 where I need to show the ranks present in chart1 with those exact rank.

For e.g: Product 4 is ranked 1 in chart1 but it is positioned 2nd in chart2, rank column will show as 1 in chart 2. Product8 & Product9 does not appear in Chart 1 so there would be no rank for those in chart2.

How to achieve this?

[Anonymous]

Hi @Sreya,

It seems like you are using long single direction relationships to link these tables.
For your requirement, I'd like to suggest you direct use the lookup function or filters to use the current value to search for corresponding ranks values from other tables.

LOOKUPVALUE – assigning of values from other table without relation (DAX – Power Pivot, Power BI) 

Regards,

Xiaoxin Sheng

[lbendlin]

Please provide more details. Are these charts fed from the same table? Multiple tables? How are the tables linked?

[Sreya]

Here is the related data model

[Sreya]

I have changed the req a little bit, can you please look into it now. I will post the related data model soon.