CODEWITHSUNDEEP
excel-formuladax
Mike
Mike

Reputation: 3

DAX expression for aggregation

Thanks in advance for helping this struggling newbie.

Can this aggregation be done with a single DAX statement?

I need to get to the "50" result using a measure if possible...

excel data screen capture

Upvotes: 0

Views: 71

Answers (1)

Owen
Owen

Reputation: 26

Here is a DAX measure performing this calculation (replace YourTable with the actual table name):

=
SUMX ( 
    VALUES ( YourTable[Item] ),
    MAXX (
        VALUES ( YourTable[Round] ),
        CALCULATE( SUM ( YourTable[Value] ) )
    )
)

This measure uses nested iterators SUMX and MAXX to iterate over the Item and Round dimensions.

Upvotes: 1

Related Questions