Adding Ranks?

Thanks for the reply from bhanu_gautam, johnt75 and SachinNandanwar, please allow me to provide another insight.
Hi Anonymous ,

I am not sure how your dataset is designed, below is my sample.

The Industry per Caps Rank table.

The Selection Parameter table.

Add the two ranks together using the following measure.

VAR _tb1 =SUMMARIZECOLUMNS('Industry per Caps Rank'[Zone],"A",[Observed Drinkers Rank])
VAR _tb2 =SUMMARIZECOLUMNS('Industry per Caps Rank'[Zone],"B",[Industry Per Caps Rank])
VAR _tb3 =
ADDCOLUMNS(
    _tb1,"C",[A]+SUMX(FILTER(_tb2,[Zone] = EARLIER('Industry per Caps Rank'[Zone])),[B])
)
   RETURN
    SUMX(_tb3,[C])

The final result is as follows, hopefully it will meet your needs.

If the above solutions do not solve the problem, please provide a sample PBIX file for us to understand the problem better and help you.

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Please see the attached pbix for reference.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.