I have data that has 2 categories , subfamily and within it Brand Name. What I am looking for is % of row totals for the subtotals a DAX formula that can solve this, I searched on the net and found a solution, but I dont understand it and I need to know what would the right calculation be in DAX. If done in Excel, it would be % of row total. I have uploaded the file.
SDA EPOS.pbix (793.2 KB)
I’d need you help on creating a cumulative total based on years 1, 2, 3 etc.:
I have created a matrix visual with the following structure
The amounts shown are: total claims= sum(payments). Columns are development years and rows are accident years coming from my data.
What I want to do is have the same table with cumulative amounts in the various columns. I mean column2 to be equal to column 1 +column2, column3 = col 1+col2+col 3 etc, giving me the result below. I suppose I need to create a new measure for total claims based on a condition relating to the development years.
Thanking you in advance for your support!
Not sure you need to create a new measure, since you are using Matrix Visual, check the Format Option and activate Total settings to see if you can get the Total for each column