Energy Pivot Prices: Bidirectional Relationships in Electricity Pivot

Energy Pivot Prices: Bidirectional Relationships in Electricity Pivot

Discover around three additional possible actual relationships brands in the database construction although not the served in the Electricity Pivot. The top style of dating was:

  • one-to-of many
  • you to definitely-to-you to
  • of many-to-of many.

A relationship are going to be build due to the fact unidirectional (we.e. streaming in one guidelines, this new standard behaviour) or bidirectional (we.age. streaming both in advice). Inside an effective unidirectional dating the filter framework are propagated on the one-front with the of several-side, yet not the other way around. Because the first step toward Stamina Rotate, the only-to-of several relationship is a routine unidirectional matchmaking. From the analogy significantly more than, the customer table is found on the newest step 1 region of the relationship additionally the Transformation table is found on the numerous side of the matchmaking (we.age. we age customers). In this case, i play with a common field ‘Buyers Key’ to join each other tables. ‘Customer Key’ listed here is used since book code that can help in order to choose for every consumer title. No duplicates of your own Customers Trick are allowed in the Customers dining table. On the other side, on the Sales dining table, ‘Customer Key’ may be used several times if there are several information of conversion to possess particular customers. This is the way that-to-of several relationships was discussed between measurement dining tables (browse tables are not on that (1) area of the dating) and you may reality tables (referred to as factual analysis tables for the of many edge of the relationship). The complete Energy Pivot Vertipaq system is actually optimised to utilize which (one of several) particular dating.

Product sales desk are filtered by the Customer table on ‘Buyers Key’ as well as the Device table was blocked into the ‘Tool Key’ with good unidirectional one-to-of numerous relationship

We create the connection amongst the Transformation table and the Calendar table, dependent brand new feature Go out. However, it ought to be noticed that inside the Electricity Rotate, singular-to-of numerous dating come, without bidirectional filter out try greeting throughout the publisher. Luckily, brand new DAX system inside Excel 2016 encourages DAX codes to reach the end result regarding a great bidirectional filter out. The DAX form CROSSFILTER adds a third argument that provide the capacity to modify the assistance from propagation of your own filter in the a love. Available arguments is Not one, OneWay and you may Each other. We’ll think of this mode later.

Why don’t we evaluate the scenario inside the Power BI. Bidirectional matchmaking are supported in Electricity BI since either BI builders should synchronise slicers to have analysis data. Let us check a straightforward analogy. You will find four (4) tables and you can relationship setup once the revealed below (amounts suggests the industries hook):

We create the breakdown of conversion depending the details and you can matchmaking above. In this case, the result would-be:

Although not, the filter out doesn’t immediately is due the sales table so you can the product desk by the unidirectional matchmaking

That it actions works okay in most problems. It’s very prominent in order to filter conversion process reliant users or products’ functions. When we want to make use of several slicers (you to towards the customer label and one towards unit identity) to help you filter out product sales, the effect table could be:

The latest statement functions while we expected. It filter systems the sales of the consumer Good. Although not, this new ‘Device Name’ slicer does not work properly. Eg, customer A great just accounts for the fresh selling of tool Cherry and you may Dragon fruits, but device Apple and Banana stay on the slicer listing. Ergo, new slicer ‘Product Name’ cannot render easy viewpoints for the customers. The reason is easy: the filter on Customers is at Conversion process, that it simply strain the sales of one’s selected buyers. When we should filter out Equipment established Consumer, we can replace the relationships anywhere between Unit and you will Conversion process to a good bidirectional dating:

Yorum Gönderin

E-posta hesabınız yayımlanmayacak.