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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
ArulselvanD07
Helper I
Helper I

Running sum in Matrix view data

I have two fact tables [FactA, FactB] and few dimension tables. Both Fact tables are indirectly linked through dimension tables and cross filtering is enabled. 

 

I am trying to produce a matrix visualization using the columns from both fact tables and measures created. For each row, I want to calculate the running sum for the measure I have selected for the "Value" Part in the matrix view.

 

Is there any property available to enable the running sum or any DAX functions available? Please let me know. Thanks for your suggestions. 

3 REPLIES 3
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @ArulselvanD07,

 

Here are some examples for your reference:

Running total

Calculating Running Totals in Power BI Using DAX

Cumulative Total

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yulgu-msft Thanks for providing the links! But I want to calculate the running sum for a measure [and not a physical column]. Is there a way we can achieve this? Thanks.

Hi @ArulselvanD07,

 

The examples mentioned in above links are calculating running total with Measures rather than column.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.