DAX Countrow Filter Userelationship not working together

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.
 
Last edited by a moderator:

gazpage

Active Member
Joined
Apr 17, 2015
Messages
393
Well, COUNTROWS only takes a single argument, and you need a comma between your FILTER and USERELATIONSHIP.
 
Last edited:

sadath

Board Regular
Joined
Oct 10, 2004
Messages
241
Hi
in COUNTROWS just put the table name only , like COUNTROWS('Schedule')
 

Forum statistics

Threads
1,077,674
Messages
5,335,606
Members
399,028
Latest member
greyland

Some videos you may like

This Week's Hot Topics

Top