topic Re: Trying to create another column using "OR logic" from two columns and to use for filtering in DAX Commands and Tips

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

DavidGM — Thu, 17 Nov 2022 02:45:19 GMT

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

Greg_Deckler — Thu, 17 Nov 2022 03:10:35 GMT

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.

DavidGM — Thu, 17 Nov 2022 03:41:10 GMT

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

Anonymous — Fri, 02 Dec 2022 07:59:09 GMT

Create a new table like below:

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