Incorrect sum in the matrix line

[Eloi_Silva]

Hi guys, my problem is as follows, I'm creating a income statement table, but my matrix, is not adding the values of the row, only returning the largest value, how to fix this?

[Eloi_Silva]

up

[v-jingzhang]

Hi @Eloi_Silva 

According to your formula, the result is composed of two variables vAliquota and vReceitaAdm. You may return these variables separately to check whether one of them or both don't work well in the Total. The second variable vReceitaAdm calculates a measure [Valor Receitas Adm] in it. What's the formula of this measure? 

vAliquota seems to be the main reason since it calculates Max, so in the Total column it also calculates Max in its section. 

Here are some solutions to fixing the incorrect total problem in Power BI. You may refer to them and find the appropriate one to your scenario.  

Power BI Matrix | How To Fix Matrix Totals In Power BI - Unlock the Power of Data

Power BI: Totals Incorrect and how to Fix it - Finance BI

Fixing Incorrect Totals Using DAX Measures In Power BI | Enterprise DNA

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.