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.

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

29.3k questions

30.6k answers

501 comments

104k users

Browse Categories

...