Forum Discussion

SchoolBoy's avatar
SchoolBoy
Frequent Visitor
6 years ago
Solved

Sum and duplicate data

Hi,   How do I calculate the total of all invoices for the following table? In this situation a single order from a specific customer may appear in several waybills. The value in “order value” fi...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    SchoolBoy , Try like

    Total__inv = SUMX(

    SUMMARIZE('waybill_table';'waybill_table'[Invoice]; 'waybill_table'[order value]);[order value])
    OR
    Total__inv = SUMX(
    SUMMARIZE('waybill_table';'waybill_table'[Invoice]; "_1";max('waybill_table'[order value]));[_1])

amitchandak's avatar
amitchandak
Super User
6 years ago

SchoolBoy , Try like

Total__inv = SUMX(

SUMMARIZE('waybill_table';'waybill_table'[Invoice]; 'waybill_table'[order value]);[order value])
OR
Total__inv = SUMX(
SUMMARIZE('waybill_table';'waybill_table'[Invoice]; "_1";max('waybill_table'[order value]));[_1])

SchoolBoy's avatar
SchoolBoy
Frequent Visitor
6 years ago

Thank you 🙂