Back to Principles: Stamina BI Matchmaking Demystified

Back to Principles: Stamina BI Matchmaking Demystified

You will find lots out-of articles throughout the complex tips out-of Power BI acting such as complex DAX, and you can framework transition. However, considering my experience with our members, I ran across there was an enormous pit inside very first blogs. Hence, this post is going to protection might principles of your own relationships. Info particularly: What exactly is a love? Why do you need it? And you will what is going on logically trailing the view of a love? More resources for Stamina BI, understand Stamina BI guide of Rookie in order to Rock Celebrity.

What is the Dating from inside the Energy BI?

Let us go through the concept of a relationship by way of an illustration; Imagine if you may have a single dining table having Store, while have to familiarize yourself with one to when you look at the Fuel BI. Our very own Store table looks like this:

From the Energy BI report, if you’d like to build a beneficial visualization the count of locations inside the County, it might be like this:

As you can plainly see, the state can be filter out the fresh dining table to exhibit brand new matter off records for each county. Easily want to picture new filtering, it might be along these lines:

Imagine if multiple table?

Now let us see what are the results whenever we convey more than one table; Let’s say there is certainly a sale table in addition to included in the answer. Sales table possess some suggestions, including exactly how many of any guide title, of which go out, from the exactly what store comes. The following is a screenshot of your investigation in the Transformation dining table;

In order to learn matchmaking, I actually do strongly recommend that turn off the automobile-choose relationships (I don’t indicate constantly! Just for the purpose of so it studying). Obtaining the car-choose matchmaking concludes you against learning what is going on at the rear of the latest world. When you need to turn off this feature, you should first check out selection out of Strength BI Pc;

Whenever we load the sales table along with in the same services, now we will have one or two tables. Without having any dating (as auto-position relationships is switched off) given that less than;

Now, whenever we want to filter to discover what is the total Qty off book headings sold in each shop, we could accomplish that having fun with a visual for example below;

This will be just like the earlier in the day visualization into Shop table. The fresh new filtering happens everything in one dining table, however, now new table is actually Sales;

Perhaps you have realized regarding the over visualization, the total from qty each condition try 493! And also the complete qty on Sales desk is additionally 493! Of course, this time around selection didn’t takes place precisely. As Conversion simply knows about the new stor_id, not the state:

If we want to filter that it desk from the store, the only profession that gives us like element is actually stor_id which doesn’t know anything regarding condition.

While doing so, a shop dining table comes with the county field, however, understands nothing regarding the Deals and Qty! Yet not, there clearly was a good stor_id occupation contained in this desk as well. Which is the book id of one’s shop each for each line (store);

Within analogy, we need one another dining tables, because they one another have industries that we you need within visualization: County career from Store table, and you may Qty occupation about Conversion process desk. This new stor_id job ‚s the field which will help united states in the looking right up that worthy of in the most other dining table. Why don’t we note that compliment of a good example:

The sales table simultaneously front side, let us know just how much conversion process we had on the store 7066 (that’s Barnum’s store);

Those two tables will be linked to both, playing with stor_id. Or can you imagine they put differently; both of these dining tables is going to be Linked to both making use of the stor_id occupation.

Napsat komentář