topic Re: PowerBI SUM issue on Totals in DAX Commands and Tips

PowerBI SUM issue on Totals

Bpaula1975 — Fri, 16 Jun 2023 09:46:23 GMT

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,

Re: PowerBI SUM issue on Totals

tamerj1 — Fri, 16 Jun 2023 10:11:21 GMT

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 )
),
"--"
)

Re: PowerBI SUM issue on Totals

Bpaula1975 — Fri, 16 Jun 2023 10:42:29 GMT

Perfect!!!!!!