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
Go to Solution.
@MariaTomova , 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])))
View solution in original post
Thank you @amitchandak It worked perfect!
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!