Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I am struggling with what should be a relatively simple issue. In Excel, using Power Pivot or a pivot table, I can select which columns where I want subtotals to appear. I have a measure that sums financial values with filters. The rows in the table are organized using a financial coding dim table that has several tiers for organizing financial data. For instance there is a sort column that organizes the data into a specific order (that matches the client's current reports), a high level category like "Income", a second tier category such as "rental income" and then a 3rd tier which breaks down the rental income by cost or accounting code. I want to subtotal by the 2nd tier only but when I select the subototal for rows I am getting either a subototal for each cost code or multiple subtotals.
Hi @7iOG, people will be able to help you better by providing a sample data and how you want the result to be.
Proud to be a Super User!
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
177 | |
85 | |
70 | |
63 | |
55 |