Forum Discussion

CSpina's avatar
CSpina
Helper III
4 years ago
Solved

Table with wrong SUM

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]

 

Need Help
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    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.

2 Replies

  • SpartaBI's avatar
    SpartaBI
    Community Champion
    4 years ago

    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.