Forum Discussion
sum from different tables
Hi Again Everyone,
I've been having this problem for kinda sometime now, I need to sum a few columns from different tables I have this measure in my table:
my main table that im using is this: (So i made a measure to this table getting from BR table)
but the outcome that i get:
(I am not sure at this point of what is causing the problem but then again from what i know there is a relationship between this "LDet2" to "BR" but still it doesn't work) my unique key is BR and yes i link them up together.
I'm really in trouble, any help would appreciate :(. If you also need the sample data i can provide.
1 Reply
Hi Anonymous
From the relationship view, it seems you didn't create a good data model.
Thus, there are two many relationship lines among tables.
You could check the following references regarding what is data model and how to create correct ones.
Building a Microsoft Power BI Data Model
Basics of Modeling in Power BI: What is a Dimension Table and Why Say No to a Single Big Table
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
