Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |