Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to Solution.
HI @Matt78
Please try
Sales € =
SUMX (
SUMMARIZE (
'Value Entries',
'Value Entries'[Item No],
'Value Entries'[Document No]
),
[Qty x Purch Price]
)
Hi,
Thank you for the quick reply, it works perfectly 🙂
BR
Matti
HI @Matt78
Please try
Sales € =
SUMX (
SUMMARIZE (
'Value Entries',
'Value Entries'[Item No],
'Value Entries'[Document No]
),
[Qty x Purch Price]
)
User | Count |
---|---|
21 | |
19 | |
12 | |
10 | |
9 |
User | Count |
---|---|
30 | |
25 | |
15 | |
13 | |
10 |