Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to sum 4 columns in my matrix. Rows are states, columns are grouped transaction types into categories "New Business, Renewals, EREs, and Endorsements." Values are premium delta filtered based on YTD using end of previous month data. I can't use a subtotal because I want to add more columns as well, like parallel time period for 2019, $ difference, % difference, persistency, and inforce premium.
Thanks in advance!
Diana
Are the columns in your matrix calculated columns, or measures ? When you say "I can't use a subtotal" do you mean you don't want the result of your calculation to appear in the bottom line of the matrix ? If you have 4 columns that are measures you should be able to write a new measure that adds those four measures together:
Sub Total = [col1] + [col2] + [col3] + [col4]
Help when you know. Ask when you don't!
My columns are a grouping of transaction type from my dataset, not measures or a calculated column. I don't want to use the column subtotals because I want to add more columns to the matrix, and I don't want those values summed in the subtotal/grandtotal.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |