The Power BI DAX functions enable you to process data from multiple tables. Some users want to obtain some data from a filtered table, then use these data to find related items in another table, and finally perform a series of operations on them. In this article, I will mainly introduce 2 parts. The first part introduces several ways to get related items from other tables. And the second part realizes the ranking of different tables based on the principles of scenario 1.