Filtering projects with different parameters

[SGB]

I have a large and complex data set that holds information on a number of projects that are being carried out across the globe but the sites have a different status and there are multiple columns on each row with information that I would like to compare.

In the example below; Project 1 is ongoing at A&B sites, Project 2 ongoing at B sites only and project 3 at A sites only.

How would i set up a filter that can compare performance across projects at A&B sites only i.e. like project 1 and not include B only and A only projects in the analysis.  Currently on Power BI if I can only get performance across all groups so aggregare data will include all A's and all B's in the analysis and i would only want to compare the performance of A and B sites when the project includes both. 

Example:

Project number	Site type
1	A
2	B
1	B
1	A
3	A
3	A
1	B
1	B
2	B

[v-easonf-msft]

Hi , @SGB 

I'm a little confused by your description.

You example  is just a table.I hope you can explain what effect you want the slicer to achieve in more detail .

Sample data and expected output would help tremendously.

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 

Best Regards,
Community Support Team _ Eason