How to do cumulative summation only for few rows in matrix

[SBC]

Hi ,

How to summation only which starts with NG_ and that summation should be shown in NG_GYM

Iam using matrix visual in power bi  exposure column was created by using dax measure

Expos = CALCULATE(SUM('TA Expos'[expo]),USERELATIONSHIP('Calendar'[Date],'TA Expos'[Trading_Period_date]))

Note:

Remaining all other curve should show the values as it is without doing any summation

Currenlty matrix visual data looks like below:

Curve	Expos	TL	HD
NG_AE	5	5	5
NG_HSC	-10	5	5
NG_DTI	-20	4	24.73
NG_GYM	-20	1	0
LNG_JK	5	1	5
AD OFF 216	5	3	5
BR_Nor	-250.72	2	5

Expected output:

Curve	Expos	TL	HD
NG_AE	5	5	5
NG_HSC	-10	5	5
NG_DTI	-20	4	24.73
NG_GYM	-45	1	0
LNG_JK	5	1	5
AD OFF 216	5	3	5
BR_Nor	-250.72	2	5

Thanks,

SBC

[ToddChitt]

No, I need to see the RAW data, not the matrix data.

Is it possible that NG-GYM is a GROUPING of NG-AE, NG-HSC, NG-DTI, and NG-GYM ? If so, create a new GROUPING on this field (in the Fields area) and pick these four 'members' to make up a Group named "NG-GYM" .

Now add this Group to the Rows portion of the Matrix and you will have a hierarchy of sorts where you can drill down NG-GYM to its componenet rows.

[ToddChitt]

 Not know what the source data in TA Expos table looks like makes it hard. Can you share sample contents?

[SBC]

Hi @ToddChitt ,

Input  like below:

Curve	Expos	TL	HD
NG_AE	5	5	5
NG_HSC	-10	5	5
NG_DTI	-20	4	24.73
NG_GYM	-20	1	0
LNG_JK	5	1	5
AD OFF 216	5	3	5
BR_Nor	-250.72	2	5

Expected output:

Curve	Expos	TL	HD
NG_AE	5	5	5
NG_HSC	-10	5	5
NG_DTI	-20	4	24.73
NG_GYM	-45	1	0
LNG_JK	5	1	5
AD OFF 216	5	3	5
BR_Nor	-250.72	2	5

Expos column in the matrix was created based on below dax measure

Expos = CALCULATE(SUM('TA Expos'[expo]),USERELATIONSHIP('Calendar'[Date],'TA Expos'[Trading_Period_date]))