Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

The expression specified in the query is not a valid table expression sumx

Hello, 
I'am trying to write this query according the tutoriel but that shows me this error : The expression specified in the query is not a valid table expression. 
This is my Dax Query 

Mesure = sumx (CALCULATETABLE('Sales SalesPerson', 'Sales SalesPerson'[Bonus]>3550.00 , 'Sales SalesPerson'[CommissionPct] <> 0.01), 'Sales SalesPerson'[Bonus])
Can you Help me please ? 
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try like

     

    sumx (filter('Sales SalesPerson', 'Sales SalesPerson'[Bonus]>3550.00 && 'Sales SalesPerson'[CommissionPct] <> 0.01), 'Sales SalesPerson'[Bonus])

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , Try like

     

    sumx (filter('Sales SalesPerson', 'Sales SalesPerson'[Bonus]>3550.00 && 'Sales SalesPerson'[CommissionPct] <> 0.01), 'Sales SalesPerson'[Bonus])