Forum Discussion
What Function should I use for Row Sum?
Question 1) If Part is "A" then sum <Part "B" WH A Qty> & <Part "C" WH A Qty> else <WH A Qty>. What function should I apply in Power BI? Part WH A Qty A 13 B 24 C 56 ...
Alternatively, if you're seeking a calculated column you could use the SUMMARIZE function
SummaryTable =
SUMMARIZE (
YourTable,
YourTable[Part],
"TotalQty",
IF (
YourTable[Part] = "A",
SUM ( YourTable[B Qty] ) + SUM ( YourTable[C Qty] ),
SUM ( YourTable[WH A Qty] )
)
)