You’ll find loads out of stuff about complex tips of Strength BI modeling such as complex DAX, and you may perspective transition. However, predicated on my personal knowledge of all of our subscribers, I discovered there was a giant pit in first blogs. Which, this post is browsing cover might concepts of your matchmaking. Resources particularly: What’s a love? So why do you need it? And what is happening logically behind the scene away from a relationship? To learn more about Stamina BI, read Strength BI guide regarding Newbie so you’re able to Stone Superstar.
What is the Relationship in the Energy BI?
Let us look at the meaning of a relationship by way of an illustration; Imagine if you really have one desk to have Store, and you need to get to know one inside Fuel BI. Our very own Shop dining table works out it:
Regarding the Fuel BI report, should you want to build a visualization which is the amount out of areas when you look at the Condition, it would be like this:
As you can tell, the state can be filter out the latest table showing the fresh new matter off details each condition. If i should visualize the newest filtering, it might be such as this:
Imagine if one or more table?
Now why don’t we take a look at what goes on when we have more than you to table; Can you imagine there clearly was a-sale table along with included in the solution. Transformation table possess some pointers, for example exactly how many of each and every book title, at which go out, during the what shop is sold. Listed here is an excellent screenshot of one’s analysis from the Conversion process table;
In order to learn matchmaking, I actually do suggest one to turn off the auto-select matchmaking (I don’t suggest usually! For only the objective of so it training). Obtaining vehicles-select relationships finishes you from studying what is happening about the fresh new world. If you want to closed this particular aspect, you ought to basic visit choices out of Stamina BI Desktop computer;
Whenever we stream product sales table along with in the same services, now we will see one or two dining tables. With no relationships (as automobile-discover matchmaking are turned-off) due to the fact below;
Today, if we need certainly to filter to see what is the overall Qty of publication titles purchased in each store, we can do that playing with a visual such lower than;
This will be just like the prior visualization into Shop desk. The filtering happens all-in-one table, although not, this time the new dining table are Conversion process;
As you care able to see in the significantly more than visualization, the from qty for each and every county is 493! While the overall qty regarding the Conversion process desk is also 493! Needless to say, now selection don’t takes place precisely. Since the Sales just knows about the newest stor_id, perhaps not the official:
Whenever we should filter out this desk because of the store, the only occupation that provides us instance feature try stor_id and therefore doesn’t know anything regarding the condition.
While doing so, a shop dining table provides the condition community, but knows absolutely nothing towards Sales and you will Qty! However, there was an excellent stor_id occupation inside desk also. Which is the novel id of your store for each for each and every line (store);
In this analogy, we truly need one another dining tables, as they each other include industries that we you prefer within visualization: Condition industry regarding Shop table, and you can Qty occupation throughout the Conversion process dining table. This new stor_id community ‘s the job which will help united states within the looking upwards one value about most other desk. Let us notice that as a consequence of an example:
The sales dining table likewise front, inform us how much cash sales we had from the store Vérifiez ça 7066 (that’s Barnum’s store);
Those two dining tables should be associated with one another, having fun with stor_id. Otherwise imagine if it this means that; those two dining tables are Related to one another utilizing the stor_id career.