How to create a report with subtotals and total in Power BI?

Question

I am currently using Power BI Designer (latest version). I am completely new to this. I am wondering how to get an interim summary of a group of items, and then get a final report. I only need the subtotal for one column (i.e. Price). The grouping will consist of 3 columns (date, location, username).

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

Answer 1

Update: The matrix is ​​now supported in both Power BI Desktop and PowerBI.com.

Just add 3 levels of grouping and the desired measure. Subtotals will not be displayed.