Forum Discussion

Matt78's avatar
Matt78
Helper II
2 years ago
Solved

DAX formula doesn't sum correctly

Hi all,

 

I have been trying to figure out what I am doing wrong in this DAX formula. I have a normal sales table where I have cost, quantity and sales. Sales = qty x cost but now the following formula calculates the yellow ones and not the greeen ones I would like to sum. What can be seen in the screen shot, the price can change and the correct total sales here would be 229 710€

 

This is my current formula, any help how to fix this would be great. Thank you.

Sales € = SUMX(VALUES('Value Entries'), [Qty x Purch Price])

 

 

Br

Matt

 

 

DAX Formulas
DAX SUMX
  • tamerj1's avatar
    tamerj1
    2 years ago

    HI Matt78 
    Please try

    Sales € =
SUMX (
    SUMMARIZE (
        'Value Entries',
        'Value Entries'[Item No],
        'Value Entries'[Document No]
    ),
    [Qty x Purch Price]
)

2 Replies

  • Matt78's avatar
    Matt78
    Helper II
    2 years ago

    Hi,

     

    Thank you for the quick reply, it works perfectly 🙂

     

    BR

    Matti

  • tamerj1's avatar
    tamerj1
    Community Champion
    2 years ago

    HI Matt78 
    Please try

    Sales € =
SUMX (
    SUMMARIZE (
        'Value Entries',
        'Value Entries'[Item No],
        'Value Entries'[Document No]
    ),
    [Qty x Purch Price]
)