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.
Hello everyone,
I have a basic visualized matrix with a basic SUM([Column]) as a column in the table. The table has a inner filter and I just use "SUM" for my calculation because it needs an aggregation to be able to show the result. So the inner Filter then splits every value in the right way. The problem is tho that it shows an overall sum for this column in this table which makes no sense for this case. But I still have another column in this table where I need the overall sum, thats why I cant disable the overall sum in the format settings.
Is there a way to edit my measure SUM([Column]) so it doesn't show the overall SUM of this specific column? I'd like just a blank spot instead.
Hi @sistancy,
The solution depends on your precise case, I guess.
If, for example, the filiter in your case is applied to the column which is not used in the row section of your matrix, you can apply a solution like the one on the screenshot below.
Best Regards,
Alexander
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
63 | |
62 | |
52 | |
39 | |
24 |
User | Count |
---|---|
85 | |
57 | |
45 | |
43 | |
38 |