Forum Discussion

Upali63's avatar
Upali63
Icon for Helper II rankHelper II
2 years ago
Solved

DAX Comparison operators do not support

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.

 

 

Need Help
Show and Tell
Tips and Tricks
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    pls try this

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

6 Replies

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    2 years ago

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

    • Upali63's avatar
      Upali63
      Icon for Helper II rankHelper II
      2 years ago

       Hi Ahmedx

      It is alraedy a numeric field

       

       

       

       

       

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    2 years ago

    pls try this

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

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    2 years ago

    you wrote the parentheses incorrectly, write it like this