PowerBI Wrong Total Sum

 Problem: DIVIDE([AC Revenue], [Ac_hl]) works per row, but totals in Matrix aggregate first, then divide — causing wrong results.
 Fix: Use SUMX to force row-wise calculation even in totals:

ppu_ac_fixed =
SUMX(
VALUES('Tabulka'[Dimenze]),
DIVIDE([AC Revenue], [Ac_hl])
)

Optional: Wrap with HASONEVALUE if you want different logic for rows vs totals.

Hi Anonymous 

For the total alone try using SUMX:

ppu_ac_custom = 
IF(
    HASONEVALUE('Tabulka'[Dimenze]),
    DIVIDE([AC Revenue], [Ac_hl]),               
    SUMX(
        VALUES('Tabulka'[Dimenze]),
        DIVIDE([AC Revenue], [Ac_hl])
    )                                          
)