The syntax for ')' is incorrect

Anonymous , 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

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

Hi Anonymous 

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.