Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
CSpina
Helper III
Helper III

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]

 

Campanhas_Power_BI_Desktop.png

1 ACCEPTED SOLUTION
SpartaBI
Community Champion
Community Champion

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.

View solution in original post

2 REPLIES 2
SpartaBI
Community Champion
Community Champion

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.

Thanks SpartaBI. That´s it!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.