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.
Hi All,
I'm pretty new in the powerBI world, and am stuck with a syntax error, hope you can help me with it.
I would like to achieve the following formula = IFERROR((Grandtotal-Outcome A- Outcome B- Outcome C- Outcome D)/ Grandtotal, 0) via PowerBI.
However, I keep receiving the "Syntax for ')' is incorrect" error, I have tried to remove some brackets or changed the type of brackets, but it still doesnt work. May I know how to fix the issue?
May refer to the following code sample I am using for DAX in PowerBI.
Test Rate 2 =
DIVIDE(
{CALCULATE({CALCULATE(COUNTROWS('Table1'), ALL('Table1'))
-
COUNTROWS('Table1'),
FILTER(VALUES('Table1'[AttemptOutcomeName]), 'Table1'[AttemptOutcomeName] IN {"Outcome A"})
-
COUNTROWS('Table1'),
FILTER(VALUES('Table1'[AttemptOutcomeName]), 'Table1'[AttemptOutcomeName] IN {"Outcome B"})
-
COUNTROWS('Table1'),
FILTER(VALUES('Table1'[AttemptOutcomeName]), 'Table1'[AttemptOutcomeName] IN {"Outcome C"})
-
COUNTROWS('Table1'),
FILTER(VALUES('Table1'[AttemptOutcomeName]), 'Table1'[AttemptOutcomeName] IN {"Outcome D"})})
,
CALCULATE(COUNTROWS('Table1'), ALL('Table1'))
)
Thank you, would really appreciate if you could help with it.
Solved! Go to Solution.
The very start of the formula begins with curly brackets, try replacing them with round ones.
DIVIDE(
(CALCULATE((CALCULATE(COUNTROWS('Table1'), ALL('Table1'))
Thank you @Anonymous
The very start of the formula begins with curly brackets, try replacing them with round ones.
DIVIDE(
(CALCULATE((CALCULATE(COUNTROWS('Table1'), ALL('Table1'))
Hi Everyone,
Below is my code in Dax Table and I am getting syntax error. Please help.
All formulas in round brackets and text in curly brackets
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 |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |