Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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]))
Solved! Go to Solution.
I changed the logic and the formula for this scenario and it worked.Thanks for your time.
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.
I changed the logic and the formula for this scenario and it worked.Thanks for your time.