Bidirectional relationships was supported in the Electricity BI as both BI builders need certainly to synchronise slicers for study data
- one-to-many
- one to-to-one
- of a lot-to-of several.
A relationship will be build because unidirectional (we.elizabeth. flowing in one assistance, the brand new default behavior) otherwise bidirectional (i.age. flowing in information). In the a beneficial unidirectional matchmaking this new filter perspective try propagated about one-side toward of a lot-side, although not vice versa. Because the first step toward Strength Pivot, the main one-to-of numerous matchmaking try a consistent unidirectional relationship. About example a lot more than, the client dining table is on new 1 section of the relationships therefore the Sales dining table is on the countless section of the matchmaking (we.e. we age consumer). In this situation, we play with a familiar industry ‘Customer Key’ to participate one another tables. ‘Customers Key’ the following is utilized given that unique password that helps so you can choose for each buyers label. Zero duplicates of one’s Buyers Secret are permitted on Customer table. On the other side, about Transformation dining table, ‘Customers Key’ can be utilized several times if you can find multiple info away from transformation getting particular consumers. This is the way one to-to-of numerous relationships are discussed between dimension dining tables (search tables commonly to your you to definitely (1) region of the dating) and you will truth tables (known as the truthful data tables into many edge of the relationship). The complete Strength Pivot Vertipaq engine are optimised to partner with which (that of numerous) sort of relationships.
I developed the connection between your Transformation desk therefore the Calendar table, reliant this new attribute Date. Although not, it must be noticed that during the Strength Pivot, only 1-to-of a lot relationship appear, without bidirectional filter out is actually enjoy regarding the editor. Luckily for us, the newest DAX engine in Excel 2016 encourages DAX rules to reach the effect of good bidirectional filter out. New DAX mode CROSSFILTER contributes a third argument that give the capacity to customize the guidance away from propagation of your filter when you look at the a romance. Available arguments become None, OneWay and Each other. We will look at this means later on.
Let us have a look at your situation in the Energy BI. Why don’t we look at a straightforward example. I have five (4) dining tables and you may matchmaking options once the revealed less than (numbers ways the newest fields hook up):
Product sales desk try blocked from the Buyers dining table into ‘Customers Key’ in addition to Unit table are filtered towards the ‘Tool Key’ which have an excellent unidirectional you to definitely-to-of many matchmaking. I create the report about sales established the content and relationship significantly more than. In this case, the result is:
Which behaviour functions okay for the majority circumstances. It can be prominent to filter out sales based upon customers otherwise products’ qualities. Whenever we want to use two slicers (one towards the buyers title and something to your unit title) in order to filter the sales, the end result dining table might be:
You’ll find around three more you can bodily matchmaking types into the database construction however all served from inside the Fuel Pivot
The new statement work even as we questioned. It strain product sales by consumer A beneficial. But not, the ‘Product Name’ slicer does not work properly. Such as, buyers A good merely makes up about this new deals out of device Cherry and you can Dragon good fresh fruit, but unit Apple and Banana stick to new slicer list. For this reason, the slicer ‘Product Name’ cannot give simple viewpoints to the end users. This is because easy: the new filter out on Customer are at Conversion process, this just strain product sales of the selected consumer. Although not, this new filter out doesn’t immediately arrives product sales table to the product table by the unidirectional matchmaking. If we must filter Unit reliant https://datingranking.net/pl/tendermeets-recenzja/ Customers, we are able to replace the dating ranging from Device and you can Conversion to help you a good bidirectional relationships:
