Hey guys,
situation is the following:
I have a sales-table containing the following columns
- Ordernumber
- Product
- Price
- Quantity
- Linetotal
The linetotal represents 'Price * Quantity' for that individual product in the specific order.
It is possible for 1 ordernumber to contain multiple products and therefore also multiple linetotals.
How do I calculate the order total (so add up all linetotals per ordernumber) using a DAX measure?
Thanks!
~ Niels
Hi @Niels_NL,
if you show these information by chart (column chart, line chart, ...) it will automatically sum and group by context(orderno/prodno) for you when you drag&drog ordernumber/productno to legend field.
And if you want to see order header and order details in same control, you should use Matrix(top left of picture) not table (top right of picture)
Hi @Niels_NL,
if you show these information by chart (column chart, line chart, ...) it will automatically sum and group by context(orderno/prodno) for you when you drag&drog ordernumber/productno to legend field.
And if you want to see order header and order details in same control, you should use Matrix(top left of picture) not table (top right of picture)
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
