Power BI having multiple ACTIVE relationships

Boris Sachansky 21 Reputation points


I have two tables with the same column names, but one is filled in with the Actual hours and costs per period, per discipline, per phase, per staff name, and the other is filled in with the budgeted hours and costs with the same details.

I have 5 filters - task description, phase, discipline, period, staff name that can be applied to both tables, and I want all of them to work simultaneously.

Sadly I can have only one active relationship between the two tables so only One filter can work.
Is there a way to have all 5 filters working simultaneously for both tables ?

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,783 questions
0 comments No comments
{count} votes

0 additional answers

Sort by: Most helpful