Forum Discussion
PowerBI DAX distinct sum
Dear,
Hope you are well.
I have a dataset as below. I'm trying to create a formula to calculate the complete_qty corresponding to each order and then sum it up (
| 18.8309393 |
from 2023090402R
+
| 14.1792 |
from 2337019R
).Because Category 1 under each order should have the same complete_qty.
So overall, complete_qty should be summed up for each order.
Thanks for any ideas.
BR
Soldier
10 Replies
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523order_no component_part_no complete_qty Category1 2023090402R 181929 18.83094 SOLVENT 2023090402R 180419 18.83094 SOLVENT 2023090402R 180699 18.83094 SOLVENT 2337019R 180196 14.1792 SOLVENT 2023090402R 213696 18.83094 PACKAGING 2023090402R 226713 18.83094 PACKAGING 2337019R 221817 14.1792 PACKAGING 2337019R 221808 14.1792 PACKAGING 2337019R 221807 14.1792 PACKAGING 2337019R 221541 14.1792 PACKAGING 2337019R 221488 14.1792 PACKAGING 2337019R 221808 14.1792 PACKAGING 2337019R 229054 14.1792 Others 2337019R 229054 14.1792 Others 2023090402R 182316 18.83094 INK 2023090402R 185773 18.83094 INK 2023090402R 1154252 18.83094 FILM 2023090402R 1154252 18.83094 FILM 2023090402R 1131288 18.83094 FILM 2337019R 1139379 14.1792 FILM 2337019R 1139379 14.1792 FILM 2337019R 1138440 14.1792 FILM 2337019R 1138440 14.1792 FILM 2337019R 186006 14.1792 ADHESIVE 2337019R 185871 14.1792 ADHESIVE
Hi lbendlin，
Thanks for your reply, please find the dataset below.
Thank you so much for your attention.
like this?
