Forum Discussion

apoje's avatar
apoje
Helper II
6 years ago
Solved

Duplicate values in multiple rows - calculation problem

Hi,   ERP returns me a sales dataset that for each item in the order returns a row in a dataset, which specifies quantity, id and the rest... however this row also contains the total order value. S...
Need Help
  • apoje's avatar
    apoje
    6 years ago

    I guess I'm going to solve it for myself :)

     

    MaxOrderAmount = MAX('Sharepoint-RAW-data-link'[OrderAmount.grossTotal])

GrossTotalOrderAmountD = SUMX(DISTINCT('Sharepoint-RAW-data-link'[Order.id]),[MaxOrderAmount])
apoje's avatar
apoje
Helper II
6 years ago

I guess I'm going to solve it for myself :)

 

MaxOrderAmount = MAX('Sharepoint-RAW-data-link'[OrderAmount.grossTotal])

GrossTotalOrderAmountD = SUMX(DISTINCT('Sharepoint-RAW-data-link'[Order.id]),[MaxOrderAmount])