Forum Discussion

Helper I

4 years ago

Solved

Suming rows (average)

Hi! My data looks something like this : Folder No Order # Amount 300 10024 $500 300 10025 $500 300 10026 $500 301 10032 $20 301 10033 $20 ...

4 years ago

Measure2 = 
SUMX (
    GROUPBY (
        _tbl1,
        _tbl1[Folder No],
        "sum", MAXX ( CURRENTGROUP (), _tbl1[Amount] )
    ),
    [sum]
)

Community Champion

4 years ago

Measure2 = 
SUMX (
    GROUPBY (
        _tbl1,
        _tbl1[Folder No],
        "sum", MAXX ( CURRENTGROUP (), _tbl1[Amount] )
    ),
    [sum]
)