Question: How to have a dynamic ranking based off of filter selection

[JG939]

Data:  

Location	Sales Rank	Cost Rank	Customer Satisifcation Rank	Inventory Rank	Average Rank	Overall Rank	Average Rank Formula	Overall Rank Formula
1	89	1	11	98	49.75	5	=(C3+D3+E3+F3)/COUNT(C3:F3)	=RANK.EQ(G3,$G$3:$G$9,1)
2	33	2	12	97	36	1	=(C4+D4+E4+F4)/COUNT(C4:F4)	=RANK.EQ(G4,$G$3:$G$9,1)
3	44	3	15	96	39.5	2	=(C5+D5+E5+F5)/COUNT(C5:F5)	=RANK.EQ(G5,$G$3:$G$9,1)
4	55	4	18	95	43	3	=(C6+D6+E6+F6)/COUNT(C6:F6)	=RANK.EQ(G6,$G$3:$G$9,1)
5	77	5	19	94	48.75	4	=(C7+D7+E7+F7)/COUNT(C7:F7)	=RANK.EQ(G7,$G$3:$G$9,1)
6	88	6	20	92	51.5	6	=(C8+D8+E8+F8)/COUNT(C8:F8)	=RANK.EQ(G8,$G$3:$G$9,1)
7	99	7	22	93	55.25	7	=(C9+D9+E9+F9)/COUNT(C9:F9)	=RANK.EQ(G9,$G$3:$G$9,1)

The goal I have in mind is a calculated column that changes the average rank formula based off of the selected criteria ie if you only wanted to rank a locatoin based off of Sales Rank and Inventory Rank. The dashboard would allow you to select any type of criteria and then have a calculation based off that selection, then rank it. 

[amitchandak]

@JG939 , not very clear

you can have dynamic rank measure like

Sales Rank = rankx(allselected(Table),[sales])

Overall Rank = ([Sales Rank]+[Cost Rank]+ [Customer Satisifcation Rank]+[Inventory Rank])/4

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

[JG939]

As I said in my comments, I know how to do what you described but I do not know how to make it dynamic, for instance if you wanted a rank with only two of the four categories.