USERELATONSHIP help

Hi PowerBIWhat ,

According to your description, I create a sample, the relationship of Shipping date and FullDate is inactive.

This is the measure code:

Measure = CALCULATE(
COUNT('Product Schedule'[Product ID]),
USERELATIONSHIP('Product Schedule'[Shipping date],'Date table'[FullDate])
)

When I don’t put measure into the product visual, it only show the first product as you say.

When I put them in the same visual, it get the correct result, I think it’s because the relationship is only active with the measure, so it has to be putted in.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.