Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
SBC
Helper III
Helper III

How 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

SBC_0-1677214942998.png

 

Thanks,

SBC

3 REPLIES 3
ToddChitt
Super User
Super User

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.




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





ToddChitt
Super User
Super User

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




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





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

SBC_0-1677245847289.png

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]))

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors