Need Measure

[NavaneethaRaju]

Hi,

I need a measure to display the data like this. Please advice how to create new measure.

[Samarth_18 · Accepted solution]

Hi @NavaneethaRaju ,

Please try this:-

Measure =
CALCULATE (
    SUM ( 'Table (2)'[QTY] ),
    ALLEXCEPT ( 'Table (2)', 'Table (2)'[ID] )
)

Output:-

Thanks,

Samarth