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:

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

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
244
Hi
in COUNTROWS just put the table name only , like COUNTROWS('Schedule')
 

Watch MrExcel Video

Forum statistics

Threads
1,090,119
Messages
5,412,554
Members
403,432
Latest member
cr2141

This Week's Hot Topics

Top