Forum Discussion

Alejandro9805's avatar
Alejandro9805
New Member
3 years ago
Solved

SUMX HELP

Good morning,   I hope you can help me,   I created a measure to calculate the opportunity $ to fulfill pending orders, the items can be repeated in different orders, this makes that when I multi...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Alejandro9805 I missed a comma:

    Opportunity $ = 
  SUMX(
    FILTER(Backorder, Backorder[B/O qty] >= RELATED('Inventory with location'[Qty on hand]) ),
    Backorder[B/O value] * RELATED('Inventory with location'[Quantity available])
  )
Alejandro9805's avatar
Alejandro9805
New Member
3 years ago

Greg_Deckler 

Thanks for you help,

 

I did what you said,

DAX CODE:

Opportunity $ = SUMX(
FILTER(Backorder,Backorder[B/O qty] >= RELATED('Inventory with location'[Qty on hand]) )
Backorder,Backorder[B/O value] * RELATED('Inventory with location'[Qty available])
)

Error:

"Backorder" syntax is not correct.(DAX(SUMX( FILTER(Backorder,Backorder[B/O cant.] >= RELATED('Inventory with location'[Quantity available]) ) Backorder,Backorder[B/O value] * RELATED('Inventory with location'[Quantity available])))).

 

 

Thanks for you help.

 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Alejandro9805 I missed a comma:

Opportunity $ = 
  SUMX(
    FILTER(Backorder, Backorder[B/O qty] >= RELATED('Inventory with location'[Qty on hand]) ),
    Backorder[B/O value] * RELATED('Inventory with location'[Quantity available])
  )