SarahOrtega
New Member
- Joined
- Nov 11, 2019
- Messages
- 1
Does anyone know why the DAX below is not working? Do I have it in the wrong order?
BTS Actual = CALCULATE(COUNTROWS('Schedule','Schedule'[Actual Count]),
FILTER('Schedule','Schedule'[WO Type]="BTS")
USERELATIONSHIP('Calendar'[Date],'Schedule'[Actual date performed]))
Power BI just keeps saying syntax error no matter what I try.
BTS Actual = CALCULATE(COUNTROWS('Schedule','Schedule'[Actual Count]),
FILTER('Schedule','Schedule'[WO Type]="BTS")
USERELATIONSHIP('Calendar'[Date],'Schedule'[Actual date performed]))
Power BI just keeps saying syntax error no matter what I try.
Last edited by a moderator: