DAX correction

[Anonymous]

Can someone help to correct  or re write the below DAX measure logic ? I am getting syntax error when I try to create a calculated measure using the below DAX.

NPT % = SUM('Sql Phases'[DURATIONPROBLEMTIMECALC])/ SUM('Sql Phases'[DURATIONPROBLEMTIMECALC]+('Sql Phases'[DURATIONNOPROBTIMECALC]-'Sql Phases'[DURATIONPROBLEMTIMECALC]))

[AlB]

Hi @Anonymous 

What are you trying to do exactly? In terms of pure syntax, the second SUM seems to missing the closing parenthesis (blue) and the very last parenthesis (red) is one too many.

NPT % = SUM('Sql Phases'[DURATIONPROBLEMTIMECALC])/ SUM('Sql Phases'[DURATIONPROBLEMTIMECALC] )+('Sql Phases'[DURATIONNOPROBTIMECALC]-'Sql Phases'[DURATIONPROBLEMTIMECALC]))

In any case, there seem to be more problems. If 'Sql Phases'[DURATIONNOPROBTIMECALC] and 'Sql Phases'[DURATIONPROBLEMTIMECALC]  are columns, you can not refer to them directly in a measure, since there is no row context.

[Anonymous · Accepted solution]

I changed the logic and the formula for this scenario and it worked.Thanks for your time.