The syntax for ')' is incorrect

[JDobski]

Hello All,

I'm sure what I'm missing is simple, just having one of those brain freeze moments!

I've had a look at the forums and can't find a fix, though I have seen similar issues.

Please look over the below and let me know what I'm missing!

RunningSum MEASURE BOTH =

VAR HomelessNotSleepingRough = CALCULATE(

SUM(atoz_homelessstatushistories[HomelessNotSleepingRough] ),

FILTER(

ALLEXCEPT(atoz_homelessstatushistories,atoz_homelessstatushistories[PersonRegion],atoz_homelessstatushistories[AgeRange],atoz_homelessstatushistories[PersonCategory],atoz_homelessstatushistories[PersonGender] ),

atoz_homelessstatushistories[LastDayOfMonth] <= MAX(atoz_homelessstatushistories[LastDayOfMonth])

))

VAR HomelessANDSleepingRough = CALCULATE(

SUM(atoz_homelessstatushistories[HomelessANDSleepingRough] ),

FILTER(

ALLEXCEPT(atoz_homelessstatushistories,atoz_homelessstatushistories[PersonRegion],atoz_homelessstatushistories[AgeRange],atoz_homelessstatushistories[PersonCategory],atoz_homelessstatushistories[PersonGender] ),

atoz_homelessstatushistories[LastDayOfMonth] <= MAX(atoz_homelessstatushistories[LastDayOfMonth])

))

RETURN

[v-xiaotang]

Hi @JDobski 

According to the grammer of your DAX expression, I think it should be a DAX column although it was named as MEASURE, right? 

then, I create a sample file and tested your Dax expression, however it works OK, or could you share your PBI file after removing sensitive information？ 

RunningSum MEASURE BOTH = 
VAR HomelessNotSleepingRough = CALCULATE(
SUM(atoz_homelessstatushistories[HomelessNotSleepingRough]),
FILTER(
ALLEXCEPT(atoz_homelessstatushistories,atoz_homelessstatushistories[PersonRegion],atoz_homelessstatushistories[AgeRange],atoz_homelessstatushistories[PersonCategory],atoz_homelessstatushistories[PersonGender] ),
atoz_homelessstatushistories[LastDayOfMonth] <= MAX(atoz_homelessstatushistories[LastDayOfMonth])
))
VAR HomelessANDSleepingRough = CALCULATE(
SUM(atoz_homelessstatushistories[HomelessANDSleepingRough]),
FILTER(
ALLEXCEPT(atoz_homelessstatushistories,atoz_homelessstatushistories[PersonRegion],atoz_homelessstatushistories[AgeRange],atoz_homelessstatushistories[PersonCategory],atoz_homelessstatushistories[PersonGender] ),
atoz_homelessstatushistories[LastDayOfMonth] <= MAX(atoz_homelessstatushistories[LastDayOfMonth])
))
RETURN HomelessNotSleepingRough

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[JDobski]

Hi @amitchandak 

Thanks for getting back to me! Frustatingly it is still giving the same 'syntax for ")"is incorrect' error. I appreciate you trying though!

-J

[amitchandak]

@JDobski , Try like

RunningSum MEASURE BOTH =
VAR HomelessNotSleepingRough = CALCULATE(
SUM(atoz_homelessstatushistories[HomelessNotSleepingRough] ),
FILTER(
Allselected(atoz_homelessstatushistories),atoz_homelessstatushistories[PersonRegion] = max(atoz_homelessstatushistories[PersonRegion]) && atoz_homelessstatushistories[AgeRange] = max(atoz_homelessstatushistories[AgeRange]) && atoz_homelessstatushistories[PersonCategory] = max(atoz_homelessstatushistories[PersonCategory]) && atoz_homelessstatushistories[PersonGender] = max(atoz_homelessstatushistories[PersonGender]) &&
atoz_homelessstatushistories[LastDayOfMonth] <= MAX(atoz_homelessstatushistories[LastDayOfMonth])
))
VAR HomelessANDSleepingRough = CALCULATE(
SUM(atoz_homelessstatushistories[HomelessANDSleepingRough] ),
FILTER(Allselected(atoz_homelessstatushistories),atoz_homelessstatushistories[PersonRegion] = max(atoz_homelessstatushistories[PersonRegion]) && atoz_homelessstatushistories[AgeRange] = max(atoz_homelessstatushistories[AgeRange]) && atoz_homelessstatushistories[PersonCategory] = max(atoz_homelessstatushistories[PersonCategory]) && atoz_homelessstatushistories[PersonGender] = max(atoz_homelessstatushistories[PersonGender]) &&
atoz_homelessstatushistories[LastDayOfMonth] <= MAX(atoz_homelessstatushistories[LastDayOfMonth])
))
RETURN