Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
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.
Hi @ArulselvanD07,
Here are some examples for your reference:
Calculating Running Totals in Power BI Using DAX
Best regards,
Yuliana Gu
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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 75 | |
| 36 | |
| 31 | |
| 29 | |
| 26 |