Error in expression ')' expected

[megan_deboer]

Hi:

Any suggestions on why I'm getting this error message:

=Sum([Month.autoCalendar.YearMonth] = {'2017-May'}[Cases-Verified])/(sum([Month.autoCalendar.YearMonth] = {'2017-May'}[Cases-Verified])+ sum([Month.autoCalendar.YearMonth] = {'2017-May'}[Cases Unbillable]))

Thank you!

Megan

[krishnacbe · Accepted solution]

Try below expression. You missed the Set Modifier and braces.

=Sum({<[Month.autoCalendar.YearMonth] = {'2017-May'}>}[Cases-Verified])/(sum({<[Month.autoCalendar.YearMonth] = {'2017-May'}>}[Cases-Verified])+ sum({<[Month.autoCalendar.YearMonth] = {'2017-May'}>}[Cases Unbillable]))

[sunny_talwar]

May be try this

=Sum({<[Month.autoCalendar.YearMonth] = {'2017-May'}>} [Cases-Verified])/(sum({<[Month.autoCalendar.YearMonth] = {'2017-May'}>} [Cases-Verified]) + Sum({<[Month.autoCalendar.YearMonth] = {'2017-May'}>} [Cases Unbillable]))

[megan_deboer]

Perfect! Thank you!