title: How do I create a report with subtotals and a grand total in Power BI?
body: <p>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, itemname).</p>
  
  <p>Power BI is connected to a Azure SQL database (not SSAS).</p>