How to Sum total from each group

DAX DAX Calculations
4

@Mike,

Give this a go:

Summ Tot = 

VAR vTable =
    SUMMARIZE(
        Data,
        Data[Region],
        Data[Qty]
    )
    
VAR Result =
IF(
    HASONEVALUE( Data[Region] ),
    MAXX(
        vTable,
        Data[Qty]
    ),
    SUMX(
        vTable,
        Data[Qty]
    )
)

RETURN
Result

image

I hope this is helpful.

  • Brian

PS - @Greg has put together a treasure trove of information on fixing incorrect totals in the DAX Patterns section of the forum (see link below):