Forum Discussion
jure_rak
Helper I
Helper IMatrix cumulative row subtotals
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
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.
1 Reply
- v-diye-msft
Community Support
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.