Matrix cumulative row subtotals

[jure_rak]

Dear all,

Could you give me a hint?

Below a simple Incom Statement:

This means, for the 1st column, MARGIN 2 should be 20.860 - 8.565 = 12.295, MARGIN 3 20.860 - 8.565 - 4613 etc.

Thanks,

Jiri

[v-diye-msft · Accepted solution]

Hi @jure_rak 

You can achieve this in the table using DAX, but the measure created won't be able to use in the column in the Matrix.

Let me know if you'd like to get below results:

M1=178

M2=178-3

M3=178-3-7

...

Add below measures:

Measure = IF(MAX('Table'[Index])=0,0,CALCULATE(MAX('Table'[Sales]),FILTER(ALL('Table'),[Index]=MAX('Table'[Index])-1)))

Measure 2 = 178-CALCULATE(SUMX('Table',[Measure]),FILTER(ALL('Table'),[Margin]<=MAX('Table'[Margin])))

Pbix attached.