Relationships between tables not working

[Anonymous]

Hi All,

I am new to Power BI and still exploring a lot of functionalites the tool has to offer. My task it to join two tables

(1) Budget

(2) Spend. 

There are duplicates in both the tables and I though joining both the tables by Department(number) is the best way. Please see attached data model.

I have created a new table called Table 3 by using the script:

Table3 = UNION (
VALUES ( '2018 Budget Plan hidden'[Department] ),
EXCEPT ( VALUES ( 'Roll-up'[Department]), VALUES ( '2018 Budget Plan hidden'[Department] ) ) )

My query still doesnt seem to work. and does not give the actuals vs budget. Appreciate your help.

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

That's because the filter road is blocked. You can change the filter direction to BOTH like it in the snapshot below.

Best Regards,

Dale