Calculating order total

[Niels_NL]

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

[tringuyenminh92 · Accepted solution]

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)