The matrix visualization has over 100 configuration options, and some of the most basic functionality, like hiding subtotals is not so easy to discover.In to. If total energies differ across different software, how do I decide which software to use? Searching "dax year over year" should give some useful results to get you started. No, the grand total row is the aggregation for all rows, it's not possible to make the grand total row to calcualte the variance between two specific rows in table/matrix. To make a copy of the visual itself containing only your selected cells, select one or more cells using CTRL, right-click, and choose Copy visual. For example, you might start with a table and then delete the details row and add column groups. Try to create a difference measure as: difference = CALCULATE ( SUM (Data [TotalVolume]), FILTER ( Data , Date [Type] <> "Baseline")) - CALCULATE ( SUM (Data [TotalVolume]), FILTER ( Data , Date [Type] <> "Scenario 1")) - Pavel Klammert Jun 24, 2019 at 12:06 Show 3 more comments 1 Answer Sorted by: 1 I have the following DAX but it does not give me the result I expect : Here is the result that I am getting which sums everything and not within the same grouping of Data[Type] Data[TotalRunDate], What I want to accomplish is this type: (which is the Difference Calculation in Excel). Table, matrix, and list data regions display data from a dataset. You can also add totals for a group or grand totals for the data region. Not the answer you're looking for? Turn off stepped layout. When you turn on Row subtotals and add a label, Power BI also adds a row, and the same label, for the grand total value. The property has a default value of true. The following figure shows the initial matrix template, selected on the design surface: You can group data by multiple fields or expressions in row and column groups. How about you take one of our courses? To format your grand total, select the format option for Row grand total. Connect and share knowledge within a single location that is structured and easy to search. I want to show the difference between the two before the total column. The Total and Subtotal API lets you customize the outgoing data query to request more aggregation or subtotal data. No, the grand total row is the aggregation for all rows, it's not possible to make the grand total row to calcualte the variance between two specific rows in table/matrix. How should I change the code if the are more columns and if I want to have the difference value calculated correctly also if a column is expanded or collapsed. What does 'They're at four. For example, select the Drill up icon. The number of rows and columns for groups is determined by the number of unique values for each row and column groups.