Forum Discussion

AxelKAp's avatar
AxelKAp
Helper I
3 years ago
Solved

DAX formula partial sum

Hello everyone,  I need your support to calculate a partial sum. Here I have a table with Purchase Order Number, Invoice Number, PO Amount Total and Invoice Amount. The issue here, I can have one ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi AxelKAp 
    Please try

    PO Amount Measure =
SUMX ( VALUES ( 'Table'[PO Number] ), CALCULATE ( MAX ( 'Table'[PO Amount] ) ) )
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi AxelKAp 
Please try

PO Amount Measure =
SUMX ( VALUES ( 'Table'[PO Number] ), CALCULATE ( MAX ( 'Table'[PO Amount] ) ) )