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.
For certain types of columns, such as text columns, it is often the case that one does not want ANY value to show in the subtotal row for that particular colmn (value), Currently, you are forced to select an aggregation type like count, count distinct first, etc. There should be a "None" option so that when records are grouped/rolled up, you can indicate that a particular field should simply not be aggregated at all.
Example:
Dept/Client/Project | Created Date | Stage | Est. Fee | Est. Profit |
Civil Engineering | 868,000 | 86,800 | ||
City of ABC | 350,000 | 35,000 | ||
Project 1 | 1/1/2025 | Fee Negotiations | 150,000 | 15,000 |
Project 2 | 2/5/2025 | Proposal Prep. | 200,000 | 20,000 |
City of XYZ | 518,000 | 51,800 | ||
Project 1 | 2/8/2025 | Lead | 310,000 | 31,000 |
Project 2 | 3/4/2025 | Selected | 208,000 | 20,800 |
Note how we have three levels of grouping in this matrix, the department, client, and the "detail" level the project. For each project, it makes sense to show values for all the columns. When rolling up to the Client level, while it does make sense to aggregate (sum) the numeric phases, in most cases it is undesirable to show any subtotal value for, in this case, the date or text columns namely Created Date and Stage.
I realize that one could include those values as matrix-rows instead of matrix-values, but typically you do not want to group your records by these fileds and just want to display their vales at that lowest level.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.