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...

Need Help

AlexisOlson
4 years ago
I can think of two separate approaches to this.

Unpivot the Team1 and Team2 columns so that you can create a relationship with both teams on the same column.

If you're just checking data, then adding a calculated column to check if [Team1] = [Team2] will help you quickly find such instances.

Forum Discussion

Create overarching filter

Related content

Create overarching level

Creating a Date Filter in Power BI

Filter

Creating relationships

Creating ICMs via Activator