PowerBI SUM issue on Totals

[Bpaula1975]

I have this table in Power BI:

The mexico and germany values ​​are masked with the following formula:

But the total is showing 118.726,350,26 instead of 74.271.657,33.

I need that the total don't SUM the hidden values.

Thanks,

[tamerj1 · Accepted solution]

Hi @Bpaula1975 

please try

Total_2 =
COALESCE (
SUMX (
VALUES ( financials[Country] ),
VAR ValorTotal =
CALCULATE ( SUM ( financials[Sales] ) )
RETURN
IF ( AND ( ValorTotal < 23900000, ValorTotal > 0 ), BLANK (), ValorTotal )
),
"--"
)

[Bpaula1975]

Perfect!!!!!!