Multiple USERRELATIONSHIP. Possible?

[some_analyst]

I have a measure which is based on the following data.

Table A:

ID, Submitted Date, Completed Date

I want to create a measure which counts IDs, which either have Sumbmitted date before the date selected from the slicer (PK_date) and no Completed date, or Completed date after the date selected from the slicer.

My relationships are with dim_date on Submitted date and Compelted date, bot inactive. 

Can someone help me with this metric? ChatGPT is not helpful

[lbendlin · Accepted solution]

USERELATIONSHIP will not help you as it requires equality. You need "before"  and "after"  so you need to keep the relationships inactive and use regular FILTER queries instead.

count = COUNTROWS(FILTER('Table A',[Submitted date]<SELECTEDVALUE(Date[PK_date]) && ISBLANK([Completed date]) || [Completed date]>SELECTEDVALUE(Date[PK_date]) )