Forum Discussion
CSpina
Helper III
Helper IIITable 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]...
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.
SpartaBI
Community Champion
Community ChampionDo 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.
CSpinaThanks SpartaBI. That´s it!