Forum Discussion
Getting wrong row subtotals in matrix table.
In our Power BI report, we have a calculated column (Column C) defined as follows: Column C = Column A / Column B. The requirement is to get the subtotals for Column C as the sum of individual rows o...
Recommend you to create and use Custom Columns under Transform rather than calculated DAX:
1. Create a Custom Column C and use the formula Column A / Column B
2. Similarly, create Custom E and us the formula Column C - Column D
Make sure the new columns are numerical
Apply the changes, and check the Sub-Totals