دسته‌هاsugar-daddies-usa+il+rockford review

What is the Guidelines out of Matchmaking in the Power BI?

What is the Guidelines out of Matchmaking in the Power BI?

In the Stamina BI, however, there’s an instruction into the dating

Dating into the Fuel BI is a while distinctive from almost every other database administration solutions. In most of one’s assistance, you simply has a relationship as there are no “Direction” for this. Brand new direction from a relationship takes on a significant role in the manner in which filtering works inside the Electricity BI. Understanding the recommendations of your matchmaking is a vital step into the new modeling in Power BI. In this article, you will observe on which the brand new guidelines of matchmaking was, and what is the difference in both directional otherwise solitary-directional dating. We’re going to maybe not discuss simple tips to eliminate the relationship problems in this article since it will make this article very much time blog post. Afterwards, I’m able to come up with an educated practices getting covering one another directional matchmaking. For more information on Power BI, see Electricity BI book away from Novice so you can Stone Star.

When you need to walk-through the latest exemplory instance of this particular article, do a separate Fuel BI Desktop document, and have research regarding AdventureWorksDW and pick DimEmployee once the merely desk locate studies out of. Here is how to access the latest AdventureWorksDW dataset;

Discover a separate Energy sugar baby in Rockford IL BI Desktop computer, while having Data of AdventureWorksDW and select these tables; DimCustomer, DimProduct, FactInternetSales. Load the info to the Fuel BI. Shortly after loading studies on Fuel BI, Throughout the matchmaking case, you really need to see every around three dining tables about each other.

1st question for you is what the guidelines away from a love mode? The clear answer try; It means Selection. Any sort of guidance of your own dating are, which means exactly how Electricity BI filter systems the information. on the over screenshot, you can see the newest advice of one’s matchmaking are of DimCustomer for the FactInternetSales. It means any column out-of DimCustomer is filter the knowledge in the fresh FactInternetSales. Including; you might cut and you may dice the newest SalesAmount (throughout the FactInternetSales table) utilising the EnglishEduction (throughout the DimCustomer), due to the fact less than;

Up to now, nothing seems unusual otherwise weird. You could potentially slice and you will dice the data of your truth dining table as well as having fun with articles out-of DimProduct, while there is a relationship assistance out of DimProduct so you’re able to FactInternetSales. The issue (or imagine if brand new uncommon area) comes when you want so you’re able to filter toward another type of assistance than simply what exactly is discussed about matchmaking. Why don’t we select a good example.

You’ll find often that you need to filter out against the guidance of the matchmaking. Let’s check an example. Let`s say you want to obtain the level of issues been bought in each training category. You may make a table which have EnglishEduction (of DimCustomer), and you may ProductKey (out of DimProduct) as the starting point. Upcoming about field’s directory of the new visual, alter the aggregation out of ProductKey so you’re able to Amount just like the found on screenshot lower than;

The outcome is the matter of products for each customers training class. But wait, the outcome will not lookup correct! They shows 606 per knowledge category!

Clearly regarding over screenshot, new matter of ProductKey are 606 for every EnglishEducation. The reason is The fresh Direction of dating. Let us glance at the advice again.

You can view the latest advice away from relationships which is always off one to area of the relationship to the brand new “many” edge of it

As you can tell from the above screenshot, merely filtering of DimProduct or DimCustomer for the FactInternetSales is actually greeting towards latest guidance of the relationship. However, that which we want to go within example was a beneficial portion different. We need to filter out DimProduct according to the group of Education in DimCustomer.

دیدگاهتان را بنویسید

نشانی ایمیل شما منتشر نخواهد شد.