Forum Discussion
some_analyst
Helper I
Helper IMultiple 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 d...
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]) )
lbendlin
Super User
Super UserUSERELATIONSHIP 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]) )