How do I create a report with subtotals and a grand total in Power BI?

Question

Currently, I'm using the Power BI Designer (newest version). I'm completely new to it. I'm wondering how to get the subtotal of a group of items and then get the report grand total. I only need the subtotal for one column (ie. price). The grouping will be on 3 columns (date, location, item name).

Power BI is connected to an Azure SQL database (not SSAS).

Answer 1

• Now, Matrix is supported in both Power BI Desktop and PowerBI.com.

• We need to add the 3 levels of grouping and the measure you want. The subtotals will show no problem.