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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
4c5da7
Frequent Visitor

Running total column for matrix

Hi all,  I'm new to power BI 

and I would like to ask a question regarding totals for column in a matrix, 

 

1.PNG

I have defined my rows, as account no.'s, 

and the the columns are composed of series of area codes, 

and for the values are the amount per account code.

 


for example in the screenshot above. 

I need ADM999 to have a total of the columns ADM100 up to ADM300 

for the account code of 5110000

 

is this possible? 

 

thanks in advance.

 

 

 

 

1 ACCEPTED SOLUTION
adityavighne
Continued Contributor
Continued Contributor

@4c5da7 

This is possible with Matrix visual.

 

I hope this will help you. accept this as a solution.

 

 

View solution in original post

2 REPLIES 2
adityavighne
Continued Contributor
Continued Contributor

@4c5da7 

This is possible with Matrix visual.

 

I hope this will help you. accept this as a solution.

 

 

Anonymous
Not applicable

Hi All,

@adityavighne @4c5da7 

Can somebody explain the solution in detail on how to achieve it?

 

Thanks in Advance.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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