USERELATIONSHIP function returns all rows from table instead of only related ones

[Anonymous]

Hello,

I two relationships between two tables.
I am trying to use the inactive one in only one measure by using the USERELATIONSHIP function.

However, the result I am getting is the total number of rows in my table, when there should be much less.

The measure I have used looks like that:

TEST = 

CALCULATE(SUM('FNG activity'[qty]),

USERELATIONSHIP('FNG activity'[sku], 'Rear Bumpers List'[sku]))

1st table name: FNG activity (related column: sku)

2nd table name: Rear Bumpers list (1st related column and ACTIVE relationship: manufacturer sku
                                                         2nd related column and INACTIVE relationship: sku)

The value I should get is 792 and instead I am getting total number of rows in FNG activity table: 4747

[Anonymous]

Thank you @amitchandak 

It worked perfect!

[amitchandak · Accepted solution]

@Anonymous , hop you are using this in measure not column ,

In case you do not want to include blank values in the join  then add

TEST =
CALCULATE(SUM('FNG activity'[qty]),
USERELATIONSHIP('FNG activity'[sku], 'Rear Bumpers List'[sku]) ,not(isblank('Rear Bumpers List'[sku])))