Forum Discussion
Getting values from 2 fact table onto a Table Viasualization
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.
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.
4 Replies
- Idrissshatila
Super User
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.
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.
- Idrissshatila
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.
