Getting values from 2 fact table onto a Table Viasualization

[camera85]

Hi All,

I'm self taught and still a beginner, went through some resources and read through the community sharing but couldn't find an exact match to what i'm enquiring.

I have 1 Dimension Table, 1 Date Table and 2 very similar Fact table.

My 2 fact table consist of data like this:

The Relationship schema looks like this:

Essentially, i'm just trying to put values from the 2 fact table onto one table:

However, when i try to insert each other's value in the table i get an error

Sorry if the question is really simple as i'm just stuck finding useful resources. Things i've done.

1) Updates master table to include all dates in both fact table

2) Ensure both Fact table have all BBG_Index as each other
3) Checked for Formatting

Would appreciate if you could point me in the right direction.

Many Thanks.

[Idrissshatila]

Hello @camera85 ,

make sure the bbg_index is from the dimension table that is linked on both facts.

is this is the case, then please share the error you're receiving by clicking on see details , or you can share a copy of the power bi file so we could investigate what's the issue here.

[camera85]

Hi, thanks for your fast response. attached the pibx file. The error says: cant determined relationships between the fields. Hope you can open the below file. Thank you.

power bi test pibx file 

[Idrissshatila · Accepted solution]

Hello @camera85 ,

the issue was that you where displaying both values un summarized, so you need to do some sort of aggregation, I did sum but you can change it as you want.

check the attached pbix.

[camera85]

@Idrissshatila Thanks for the solution. It works as intended now. 

Can i just clarify that these 2 summation are not the same thing and are mutually exclusive from one another.

Table View:

Report View:

Thank you