Forum Discussion
DAX correction
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]))
2 Replies
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.
