Report Portal

Bidirectional relationships and ambiguity in DAX

A relationship can be set to be unidirectional – its default behavior – or bidirectional. In a unidirectional relationship the filter context is propagated from the one-side to the many-side, but not the other way around. In other words, in the following diagram a filter on Customer automatically filters Sales, whereas a filter on Sales propagates neither to Product nor to Customer or Date.

Read more...

 

Tags: design, dax, tabular

 

2007-2015 VidasSoft Systems Inc.