What is the syntax error?

Questions & Answers
1 
Sum(
  {[Status].CurrentMember[Published] = "Published"},
  [Measures].[Issues resolved]
)

Formula is not valid:
Syntax error at line 2, column 26, token ‘[Published]’

2

Hi @irv45,

The Sum() function requires i two input parameters:

  • set of members from which to read the numeric value
  • numeric value you would like to sum up for each member

Thsi expression {[Status].CurrentMember[Published] = “Published”} is not a valid set of members.

If you would like to get a count of resolved issues in status published, you should use a tuple expression like this:

(
  [Measures].[Issues resolved],
  [Status].[Published]
)

More details on calcauted measures and when to use set functions like Sum() and when a tuple expression are here: Calculated measures.

Best,
Zane / support@eazyBI.com