USERELATIONSHIP in a filtered measure

[sarah-ortega]

I'm trying to countrows whilst using a userelationship and filter. Not working so far...any ideas? 

BTS Actual = calculate(COUNTROWS('Schedule',Schedule[Actual Count],

USERELATIONSHIP(Calendar[Date],'Schedule'[Actual date performed])

Filter('Schedule',Schedule[WO Type]="BTS")

)

[technolog]

Here's how you can adjust your DAX formula to correctly use USERELATIONSHIP in conjunction with FILTER and CALCULATE:

BTS Actual =
CALCULATE(
COUNTROWS('Schedule'),
USERELATIONSHIP(Calendar[Date],'Schedule'[Actual date performed]),
'Schedule'[WO Type] = "BTS"
)