Matrix Totals & Visual issue

1️⃣ Adapt “Actual Consumption” to show totals in a Matrix

The problem is usually that the measure works per row, but Power BI doesn’t automatically sum it at the total level. The solution is to detect whether you are at the row level or total level using HASONEVALUE() (or ISINSCOPE()), then calculate accordingly.

Pattern for totals:

Actual Consumption Total =
IF(
HASONEVALUE('Table'[Plant]), -- Or the field used for rows
[Actual Consumption], -- Your original row-level calculation
SUMX(
VALUES('Table'[Plant]), -- Iterate over all plants
[Actual Consumption] -- Sum the original measure
)
)

Alternative using ISINSCOPE (modern approach):

Actual Consumption Total =
IF(
ISINSCOPE('Table'[Plant]),
[Actual Consumption],
SUMX(
ALL('Table'[Plant]),
[Actual Consumption]
)
)

✅ This ensures the Matrix totals display correctly, summing across all plants or categories.

---

2️⃣ Visualizing 3 measures correctly

Assuming your 3 measures are:

1. Actual Consumption

2. Theorical Sales

3. Sales ACT vs Theorical

Step 1: Choose the right chart type

Measure Recommended Visual Notes

Actual Consumption Column chart Displays absolute values per category (Plant, Date, etc.)
Theorical Sales Line or Column Use a combo chart with Actual Consumption as column, Theorical as line
Sales ACT vs Theorical Line or Bar (secondary axis optional) Can be plotted as difference line on the same combo chart

---

Step 2: Use a Combo Chart for all 3 measures

1. X-axis: Category (Plant, Month, or Date)

2. Column values: Actual Consumption + Theorical Sales (stacked or side-by-side)

3. Line value: Sales ACT vs Theorical (difference measure)

4. Y-axis: You may use dual axis if scales differ

5. Formatting:

Show data labels on columns

Use color coding: Blue = Actual, Grey = Theorical, Red = Difference

---

Step 3: Test measures individually

Always validate each measure using a Card visual.

Ensure all measures return numeric values, not blanks.

Once confirmed, they’ll render correctly in the combo chart.

---

Bonus Tip for Matrix Totals

If you also need Theorical Sales totals in the Matrix:

Theorical Sales Total =
IF(
ISINSCOPE('Table'[Plant]),
[Theorical Sales],
SUMX(
ALL('Table'[Plant]),
[Theorical Sales]
)
)

Same logic applies to any calculated measure.

This pattern fixes totals for measures that are row-level calculations or calculated differences.