Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
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).


1 Answer

0 votes
by (47.2k points)
selected by
Best answer
  • Now, Matrix is supported in both Power BI Desktop and

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

Related questions

0 votes
1 answer
0 votes
1 answer
asked Feb 3, 2020 in BI by Vaibhav Ameta (17.6k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers


94.1k users

Browse Categories