You will find lots out-of posts throughout the advanced resources away from Electricity BI acting for example complex DAX, and you may framework change. Yet not, considering my personal knowledge of all of our readers, I came across there clearly was a big gap inside very first stuff. And that, this article is gonna security the basic tips of one’s relationship. Information for example: What is actually a romance? How come you really need it? And you will what’s going on rationally about the scene out of a love? For more information on Electricity BI, comprehend Energy BI guide from Newbie to help you Rock Star.
What’s the Matchmaking when you look at the Electricity BI?
Let’s go through the meaning of a romance through an example; What if you have one dining table having Store, while need to familiarize yourself with one to in the Stamina BI. The Shop dining table looks like so it:
On the Strength BI report, should you want to build a beneficial visualization the number away from places during the State, it will be along these lines:
Perhaps you have realized, the state normally filter out brand new table showing the fresh matter from facts each county. If i must visualize the fresh filtering, it would be like this:
Can you imagine multiple table?
Now let’s look at what are the results whenever we convey more than simply one to table; Can you imagine there clearly was sales desk also included in the solution. Conversion dining table involve some recommendations, such how many of each and every guide name, from which time, within what store is available. We have found a beneficial screenshot of your studies regarding Sales dining table;
In order to discover dating, I really do strongly recommend one turn off the car-position matchmaking (Really don’t mean constantly! Just for the objective of it learning). Having the vehicle-locate relationship ends you against training what is happening trailing the fresh new world. If you wish to turn off this feature, you should basic go to options out of Strength BI Pc;
If we stream product sales dining table plus in identical solution, today we will see a couple of dining tables. Without any matchmaking (due to the fact auto-position relationship was turned off) because lower than;
Today, if we want to filter and watch what’s the full Qty away from publication headings sold in each store, we can accomplish that playing with a visual like less than;
This will be similar to the earlier in the day visualization on Store table. Brand new selection happens all-in-one table, but not, this time around the new dining table try Transformation;
As you can see on the significantly more than visualization, the total from qty for every county is actually 493! Plus the overall qty regarding Conversion table is even 493! Without a doubt, now selection 
failed to takes place correctly. Because Transformation simply is aware of new stor_id, maybe not the state:
If we have to filter out which desk by shop, the only career providing you with us such as for instance ability is stor_id and therefore cannot know any single thing in regards to the condition.
On the other hand, the store table contains the condition industry, but understands little regarding Revenue and you can Qty! However, you will find an excellent stor_id industry contained in this table also. Which is the book id of store for each and every for each row (store);
Contained in this analogy, we are in need of both tables, while they one another incorporate fields we you would like within visualization: County community regarding Shop desk, and you will Qty job from the Transformation table. The fresh new stor_id occupation is the field that will help united states in the lookin up one really worth in the almost every other desk. Let’s see that because of an illustration:
Product sales desk concurrently top, tell us just how much transformation we had from the shop 7066 (that’s Barnum’s shop);
Those two dining tables would be associated with both, playing with stor_id. Or imagine if it put differently; these two tables are Linked to each other utilizing the stor_id occupation.