power bi groupby experession sum code example
Example: power bi sum group by
Total value by category =
VAR
category = [Category]
RETURN
CALCULATE(SUM([Value]), FILTER(Table1, [Category] = category))
Total value by category =
VAR
category = [Category]
RETURN
CALCULATE(SUM([Value]), FILTER(Table1, [Category] = category))