You can turn subtotals on or off in matrix visuals, for both rows and columns. ... When you turn on Subtotals and add a label, Power BI also adds a row, and the same label, for the grand total value.

What is your subtotal?

SUBTOTAL: This is the total price for each product in your order or the total price found for a selected delivery window in your order. If you also have a discount applied to a product, then you will find the updated discount price total for that particular item or delivery window in your order.

What is SUMX Power BI?

SUMX is an iteration function in Power BI that works on a row by row calculation as per the expression or equation is given. ... This will not concentrate on the entire column, unlike the SUM function do, but it works like a cell be cell formula in excel. SUM is an aggregate function, and SUMX is an expression function.