# Dax Matrix Questions

Hi All,
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)

``````Hi team!
``````

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.