Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
pouriam
Regular Visitor

Rankx by external filter

Hi, I have these two tables in power bi which are connected on the Company Names.

pouriam_0-1701257254401.png


I have a slicer on the company names, so i could select a company, for example Shell PLC, that has Oil, Gas & Consumable Fuels as the industry from table 1. I want to have table visual for table 2, that shows all the companies with Oil, Gas & Consumable Fuels as Industry and a mesure that ranks the companies in that category. How could achieve that? 

1 REPLY 1
amitchandak
Super User
Super User

@pouriam , for that Table 1 should not join with Table 2, it should be a disconnected table. Or have a duplicate table without joining and then create a measure like and use in visual

 

countrows(filter(Table2, Table2[CompanyName] in values(table1[CompanyName]) ) )

 

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.