Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Matt78
Helper II
Helper II

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])

 

sales screenshot.png

 

Br

Matt

 

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

HI @Matt78 
Please try

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

View solution in original post

2 REPLIES 2
Matt78
Helper II
Helper II

Hi,

 

Thank you for the quick reply, it works perfectly 🙂

 

BR

Matti

tamerj1
Super User
Super User

HI @Matt78 
Please try

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors