Forum Discussion
Multiple USERRELATIONSHIP. Possible?
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
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]) )
1 Reply
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]) )