Inside the Energy BI, although not, there was a training toward relationships
Relationships into the Electricity BI are a while not the same as other databases administration options. In most of expertise, you merely enjoys a romance and there’s zero “Direction” because of it. New recommendations away from a love performs a serious part on the manner in which filtering works within the Electricity BI. Knowing the direction of your matchmaking is an important step to the the fresh new modeling during the Energy BI. In this post, you will see on which brand new assistance of your own matchmaking was, and you can what’s the difference between both directional or unmarried-directional matchmaking. We are going to not talk about how-to manage the relationship problems in this post because it will make this information extremely long blog post. Later on, I could come up with the best techniques for layer each other directional relationship. For additional information on Strength BI, discover Electricity BI book out-of Novice to help you Rock Celebrity.
If you’d like to walk through the fresh new exemplory instance of this short article, create an alternate Energy BI Desktop file, and now have study out-of AdventureWorksDW and choose DimEmployee while the merely desk to get analysis away from. Information on how to access the AdventureWorksDW dataset;
Unlock an alternative Strength BI Pc, and now have Data out of AdventureWorksDW and select such tables; DimCustomer, DimProduct, FactInternetSales. Stream the information into the Energy BI. Shortly after packing data towards Power BI, On the matchmaking tab, you will want to get a hold of every about three dining tables linked to one another.
One question is just what assistance off a romance setting? The clear answer try; This means Filtering. Whichever advice of one’s relationship is, that implies exactly how Electricity BI filter systems the information. on significantly more than screenshot, you can find the new guidelines of matchmaking was out of DimCustomer for the FactInternetSales. It means any column from DimCustomer normally filter out the content from inside the the FactInternetSales. Such as; you can cut and chop the brand new SalesAmount (in the FactInternetSales dining table) using the EnglishEduction (on DimCustomer), once the lower than;
Yet, little appears unusual or odd. You can slice and you can chop the content of the reality table in addition to having fun with columns of DimProduct, while there is a romance guidance of DimProduct to 
FactInternetSales. The trouble (or what if brand new uncommon area) comes when you need to filter out toward a separate recommendations than simply what’s discussed from the relationship. Let’s pick a good example.
You can find often that you should filter up against the advice of relationships. Why don’t we check an example. Let’s hypothetically say we should obtain the number of issues come purchased in for every single training category. You possibly can make a desk having EnglishEduction (away from DimCustomer), and you may ProductKey (out-of DimProduct) just like the first rung on the ladder. Up coming on field’s selection of the new artwork, change the aggregation of ProductKey in order to Count while the shown on the screenshot lower than;
The effect are the number of products for each and every buyers knowledge classification. However, wait, the end result doesn’t look best! It shows 606 for each and every education classification!
As you can see on more than screenshot, the new matter regarding ProductKey try 606 per EnglishEducation. The reason is The fresh Guidelines of your relationships. Let’s go through the guidance again.
You will see the fresh new guidance out of relationship that is always off you to definitely region of the relationship to the brand new “many” edge of it
Perhaps you have realized on the above screenshot, just filtering of DimProduct or DimCustomer on FactInternetSales is enjoy on the latest guidance of the matchmaking. not, that which we are attempting to go in this analogy is a good bit various other. You want to filter DimProduct in line with the set of Education inside the DimCustomer.
