Forum Discussion
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
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
