Trying to create another column using "OR logic" from two columns and to use for filtering

[DavidGM]

Hi All, 

I want to create another column using OR Logic between column 1, column 2

Table = Summary

                        column 1 = team,

                         column 2= shared team,

Purpose of that new table will be to use it for filtering, I want to see all the records in single column if col1 team or col2 shared teams..

If need more information please send an email at shahfx@outlook.com

thanks

thanks

[v-jayw-msft · Accepted solution]

Hi @DavidGM ,

Create a new table like below:

Table 2 = DISTINCT(UNION(VALUES('Table'[Team]),VALUES('Table'[Shared Team])))

[DavidGM]

Team                                                                                                     Shared Team

Integration	Main Integration
	Main Integration
Integration
Integration	Main Integration
Security	Security Team
Development	Custom Develop
	Custom Develop
Testing	Testing Team
	Testing Team
Database	Testing Team
Selection option for Team and/or shared Team to be selected.

So I like to show all the work assigned to team member using team column OR shared team coloumn 

[Greg_Deckler]

@DavidGM Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, 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

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.