Unable to rollup(SUM) lower level hierarchy values at higher level in PBI/DAX

[vishal10306]

As per the above table currently we've used a measure "Price" which gives the correct values at item level however it doesn't roll up(SUM) to give 0.28 value at manufacturer level.

Measure Used: Price = IF( SELECTEDVALUE('VAL/VOL'[VAL/VOL])="VAL TOTAL (USD)",CALCULATE(([MS Value] - [MS Value PY]),'VAL/VOL'[VAL/VOL]="Price (USD)")*CALCULATE([MS Value PY],'VAL/VOL'[VAL/VOL]="Vol Total"))

Price (USD) = VAL TOTAL (USD) / VOL TOTAL

Please suggest some solution to rollup Price values at manufacturer level.

[Jihwan_Kim]

Hi,

I am not sure how your datamodel looks like, but I assume Brand column is a subset of Manufacturer column.

Please try the below whether it suits your requirement.

New measure: =
SUMX ( DISTINCT ( 'TableName'[Brand] ), [Price] )