Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Greetings Community Members:
I am new learner. I was applying the Table Expression Filter CALCULATE DAX Function with FILTER DAX inside it as under:
MdxScript(Model)(70:93) Calculation Error in Measure
'Sales'[Country Wise Sales]:cannot convert value 'United States' of Type Text to Type True/False
It looks that I am at fault. However, I am not getting clear about the error and can't resolve the error.
Kindly help in this regard.
The Screen Shot is attached hereunder:
Yours truly,
Rehan Sheikh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @RehanSheikh,
According to the error message, you are using a Text fields as the argument of FILTER function which is not allowed. According to the syntax of FILTER, the second parameter should be a Boolean expression that can be used to filter the table specified as the first parameter. FILTER function (DAX) - DAX | Microsoft Docs
Therefore, you need make some changes to your formula.
Or
Best Regards,
Community Support Team _ Caiyun