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.

tez's avatar
tez
Resolver I
4 years ago

Thanks for the feedback. I worded that in a misleading way: I didn't mean that USERELATIONSHIP was generally redundant. I just had the impression that it would seemingly not be necessary in this context of the FILTER function. Is that correct?

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    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.