Ratio/Percent of Volume using DAX

[IronMike15]

need to calculate per piece cost from the column below using DAX. In normal excel it would be simple -make another column and divide with volume on each cell. Please help

Attribute	Value
Volume	25
Service Cost	55
Advertising cost	67

[FreemanZ]

@IronMike15 you expectation is not clear to me. could you elaborate that?

[Dangar332]

Hi, @IronMike15 

Try below measure

Just adjust your table name and column name

Result=

Var a = sum('your table name'[value])

Var b = calculate (sum('your table name'[value]), removefilter('your table name'[attribute]))

Return

Divide (a,b)