select a value from company from slicer should return companies from the industry it belongs to.

[rschaudhr]

I have a company name slicer and it shows only value of the company I have selected as shown below:

In the above example, I have selected LiveWorld, Inc and it belongs to industry called Internet software & service. However, what I want to do is I want to select LiveWorld, Inc and it should return all companies in the indusrty in my case internet software & service. It should look like below:

So, In the above example I have selected LiveWorld and it is returning all the companies within Internet software and services belong to. 

Also, company name and industry are one table. 

I hope this is clear. 

Thank you in advance.

[gadielsolis]

The detail you want to show for the selected company is the industry only or there are other details from different tables yoy want to show?

[gadielsolis]

Hello,

My suggestion would be the following:

     1-Create a new table with the fields company and industry (this can be achieved using summarize)

     2-Create a slicer with the field Company from the new table

     3-Use the following dax to filter the values based on the selected company in the slicer:

Then you can add the company field in a matrix (the one from the original table) and the measure in values and this will be filtered based in the industry assigned to the selected company in the slicer:

[rschaudhr]

Another thing I have noticed is that if I bring in additional fields in the filter table, it shows the first value only. 

[rschaudhr]

Thank you for your replay. It worked perfectlyfor what I had asked.  However, I do want one visual that will show the details of the company I had selected. So, in essence, I am looking for one visual that has details on one company and another visual that has details on all the companies within the industry of the selected company. 

[rschaudhr]

Another thing about this  I have brought in other fields in summarize filter table and it seems that only the first value is displayed.