Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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'[DURATIONPR...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

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

AlB's avatar
AlB
Community Champion
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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