Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (17.6k points)

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).

closed

1 Answer

0 votes
by (47.2k points)
selected by
 
Best answer
  • 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.

Browse Categories

...