summarize power bi and max value code example
Example 1: power bi sum with filter
Sum = CALCULATE(SUM(Qty);FILTER(Status=C))
Example 2: power bi sum group by
Total value by category =
VAR
category = [Category]
RETURN
CALCULATE(SUM([Value]), FILTER(Table1, [Category] = category))