Top Items (Comparison / Lookup)

Hi Oros ,

The Table data is shown below:

Please follow these steps:

1. Use the following DAX expression to create a column in table 'BOB'

Rank = RANKX('BOB',[Sales],,DESC,Skip)

2.Use the following DAX expression to create a column in table 'COMPANY'

Rank = RANKX('COMPANY',[Sales],,DESC,Skip)

3.Use the following DAX expression to create a measure

Measure = 
VAR _Top5_BOB = SELECTCOLUMNS(FILTER('BOB','BOB'[Rank] <= 5),"Top 5",[Product])
VAR _Top5_COMPANY = SELECTCOLUMNS(FILTER('COMPANY','COMPANY'[Rank] <= 5),"Top 5",[Product])
VAR _Result = ADDCOLUMNS(_Top5_COMPANY,"samewithBOB",IF([Top 5] IN _Top5_BOB ,BLANK(),[Top 5]))
RETURN CONCATENATEX(FILTER(_Result,[samewithBOB] <> BLANK()),[samewithBOB],",")

4.Final output

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