Table with wrong SUM

[CSpina]

Hi, guys,

I have created a table, but the sum in the bottom line is wrong

Measures

Vendas = SUM(fFaturado[Total])
///////////////
%Premio = 
VAR varPedidos = DISTINCTCOUNT(fFaturado[Pedido])

RETURN
IF(
    varPedidos >= 8
    , 0.05
    , IF(
        varPedidos >= 4
        , 0.03
    , 0
    )
)
///////////////
Premio = [Vendas] * [% Premio]

[SpartaBI · Accepted solution]

Do you want it to be 598.56 + 0.00? 
If yes, what do you have on the rows of your visual? "Razao Social"?
If yes then write:
Premio = SUMX(VALUES('Table'[Razao Social], [Vendas] * [% Premio])
Instead of 'Table' put the name of the table where the column [Razao Social] is.

[CSpina]

Thanks SpartaBI. That´s it!