Forum Discussion

Niels_NL's avatar
Niels_NL
Advocate I
9 years ago
Solved

Calculating order total

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

Need Help
  • tringuyenminh92's avatar
    tringuyenminh92
    9 years ago

    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)

     

     

     

     

     

1 Reply

  • tringuyenminh92's avatar
    tringuyenminh92
    Memorable Member
    9 years ago

    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)