cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MaxSchrijen23
Helper I
Helper I

Create overarching filter

I want to create a that filters on two columns, containing the same data, at the same time.

The table I have contains three columns, a projectName, a column containing team 1 that is attached to the project and a column team 2 that contains the second team which is attached to the project. These teams are attached via the persons working on the project, so it can be the case that the teamname in columns "Team1" and "Team2" are the same if the two persons in the project are part of the same team. 

Can I then in some way create a filter, or add a column which allows me to filter on columns "Team1" and "Team2" at the same time? Such that I can check if there are project which have the same team attached twice.

 

Kind regards!

1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

I can think of two separate approaches to this.

 

  1. Unpivot the Team1 and Team2 columns so that you can create a relationship with both teams on the same column.
  2. If you're just checking data, then adding a calculated column to check if [Team1] = [Team2] will help you quickly find such instances.

View solution in original post

3 REPLIES 3
AlexisOlson
Super User
Super User

I can think of two separate approaches to this.

 

  1. Unpivot the Team1 and Team2 columns so that you can create a relationship with both teams on the same column.
  2. If you're just checking data, then adding a calculated column to check if [Team1] = [Team2] will help you quickly find such instances.

Thanks for your reply, it worked!

 

vanessafvg
Super User
Super User

can you please provide some data or dummy data?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Kudoed Authors