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 getting this following error while executing the below DAX. Could anyone pls help me to find to what went wrong?
A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed.
Many Thanks,
Praveen.
Solved! Go to Solution.
Hi @Anonymous,
look at the error and on your DAX statement.
Your second CALCULATE in filter expression of your first CALCULATE is not allowed.
Calculate Syntax: CALCULATE ( <Expression> [, <Filter> [, <Filter> [, … ] ] ] )
Best Regards,
Marcus
Hi @Anonymous
maybe your closing bracket (Line 10) is on the wrong line and it belongs to the first CALCULATE (Line 4).
Hi @Anonymous
maybe your closing bracket (Line 10) is on the wrong line and it belongs to the first CALCULATE (Line 4).
Hi @Anonymous,
look at the error and on your DAX statement.
Your second CALCULATE in filter expression of your first CALCULATE is not allowed.
Calculate Syntax: CALCULATE ( <Expression> [, <Filter> [, <Filter> [, … ] ] ] )
Best Regards,
Marcus
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |