Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I am facing an issue calculating a subtotal column. I tried to use CALCULATE SUM with FILTER but it does not really work.
Maybe somebody has a good idea? 🙂
Current Matrix Visual View:
2024 | 2025 | 2026 | |
Apples | 4 | 10 | 23 |
Bananas | 5 | 67 | 43 |
Cucumber | 2 | 6 | 3 |
TOTAL | 11 | 83 | 69 |
Trying to get this view with calculated row:
2024 | 2025 | 2026 | |
Apples | 4 | 10 | 23 |
Bananas | 5 | 67 | 43 |
SUBTOTAL FRUITS | 9 | 77 | 66 |
Cucumber | 2 | 6 | 3 |
SUBTOTAL VEGETABLES | 2 | 6 | 3 |
TOTAL | 11 | 83 | 69 |
Appreciate any ideas and feedback.
Kind Regards
Solved! Go to Solution.
@tim_001 You could get something like this if you add a column to identify Fruits and Vegetables in your table. Otherwise, you are looking at a disconnected table and a single measure that identifies the row it is in and returns the appropriate calculation.
Hi @Greg_Deckler Thanks. So I would make another column that says if "Apple" then "Fruit" and so on. And then I can make a SUMIFS based on that column?
Hi, I added a column and used this formula:
If(containstring(columnname, "X"), "desired", "none")
Now I just moved that in the first order of the matrix visual. So I have the Subtotal as one row and you can expend from there. I think this is the easiest way thanks.
Hi, I added a column and used this formula:
If(containstring(columnname, "X"), "desired", "none")
Now I just moved that in the first order of the matrix visual. So I have the Subtotal as one row and you can expend from there. I think this is the easiest way thanks.
@tim_001 You could get something like this if you add a column to identify Fruits and Vegetables in your table. Otherwise, you are looking at a disconnected table and a single measure that identifies the row it is in and returns the appropriate calculation.
Hi @Greg_Deckler Thanks. So I would make another column that says if "Apple" then "Fruit" and so on. And then I can make a SUMIFS based on that column?
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |