For some rows, the Total or Grand Total is not displayed in the Power BI matrix.

edit

There could be several reasons why the Total or Grand Total is not displayed in the Power BI matrix. Here are some possible solutions:

1. Check the settings: Make sure that the "Subtotals" and "Grand Totals" options are turned on in the matrix visualizations settings. To do this, select the matrix visual and navigate to the formatting menu, then turn on the "Subtotals" and "Grand Totals" options.

2. Check the data model: Ensure that the measure you are using to aggregate data is correctly defined in the data model. If the measure is not correctly defined, the Total and Grand Total will not be displayed.

3. Check the column settings: Make sure that the column where you expect to see the Total or Grand Total is not hidden or has been removed from the matrix.

4. Check the data: If the Total or Grand Total is not displayed, it may be due to the absence of values in one or more cells. This could happen when there is a filter applied to the matrix or when the data model contains null or blank values.

If none of these solutions work, try reviewing the Power BI community forum for additional guidance, or contact Power BI support for further assistance.