Forum Discussion
Helper IIIHow to do cumulative summation only for few rows in matrix
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
3 Replies
- ToddChitt
Super User
Not know what the source data in TA Expos table looks like makes it hard. Can you share sample contents?
SBCHi 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]))
- 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.
