DAX Comparison operators do not support

[Upali63]

Hi Friends

Prd_Sales = CALCULATE(sum(GLT_DATA[AMOUNT]),GLT_DATA[TBL_FLG])="SA"

I have created the above  measure and when I try to use the same with a visual I get below message. I dont know how to solve it. Kindly help please.

[Ahmedx]

you wrote the parentheses incorrectly, write it like this

[Ahmedx · Accepted solution]

pls try this

Prd_Sales = CALCULATE(sum(GLT_DATA[AMOUNT]),GLT_DATA[TBL_FLG]="SA")

[Upali63]

Thanks a lot

[Ahmedx]

Share sample pbix file to help you.

[Ahmedx]

you need to convert the GET_DATA[AMOUNT] column to a number in power query

[Upali63]

 Hi Ahmedx

It is alraedy a numeric field