Line Item sum for unique label

[ktbam_7]

Hello,

I have below sample data and need a measure to calculate a sum of each unique package label based on the individual package IDs:

Package Label	Package ID	Line Item Cost
45557	1110	$995.95
45557	1118	$493.00
45557	1119	$948.05

I need an outcome like this:

Package Label	Package ID	Line Item Cost	Total Package Cost
45557	1110	$995.95	$2,437.00
45557	1118	$493.00	$2,437.00
45557	1119	$948.05	$2,437.00

I have tried the below in DAX, but the measure just returns the line item cost again:

Unique Package Label Costs = SUMX(VALUES('table'[package label]),CALCULATE(SUM('table'[line item cost])))
Unique Package Lable Costs = SUMX(DISTINCT('table'[package label]),CALCULATE(SUM('table'[line item cost])))

Thanks,

Alex

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Total package cost: =
CALCULATE (
    SUM ( 'table'[Line Item Cost] ),
    ALLEXCEPT ( 'table', 'table'[Package Label] )
)

[ktbam_7]

This worked. Thank you!

[powerbiexpert22]

Hi @ktbam_7 

please try below

CALCULATE(SUM(table[Line Item Cost]),FILTER(All(table),

table[Package Label]=MAX(table[Package Label])))

[ktbam_7]

This worked as well! Thank you.