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.
The method of union filtered data and then rank.pbix