Report Portal

DAX 101: Using USERELATIONSHIP in DAX

This article shows how to use the USERELATIONSHIP function in DAX to change the active relationship in a CALCULATE function.

If two tables are linked by more than one relationship, you can decide which relationship to activate by using USERELATIONSHIP. Indeed, you can only have one active relationship between any two tables. For example, you start with a model where Sales is related to Date through the Date column, like in the following picture.

Read more...

 

Tags: dax, tabular

 

2007-2015 VidasSoft Systems Inc.