Forum Discussion

tez's avatar
tez
Resolver I
4 years ago
Solved

FILTER() makes USERELATIONSHIP() superfluous?

I have two tables (simplified):   Table A: StartDate, EndDate, ... Table B (Datetable): Date, ...   Table A StartDate has an active relationship to Table B Date, Table A EndDate has an inactive ...
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    The relationships are not being used with the way your calculated columns are written. Since there isn't a CALCULATE transforming the row context to filter context, Table A isn't filtered by Table B except as you explicitly define the filter, so which relationship is active doesn't affect the calculation.

     

    This wouldn't work (and couldn't be written) quite the same way if these were measures instead of calculated columns.

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

There are multiple ways to propagate filters in DAX. That doesn't mean one or the other is "superfluous".

 

The biggest difference is that FILTER is flexible but virtual whereas USERELATIONSHIP is more limited but physical.

 

I recommend this article which covers multiple filter propagation techniques and compares their performance:
https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/