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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
leandrocsouza
Frequent Visitor

Sum the total for a column showing the values ​​in the column, but if the number is negative, show 0

Good morning,
I need to add up the column, but if the total is negative, I have to show zero.
But in the column must appear the negative numbers.
I tried to make this measurement, but it's giving me 0,00 in the column and I can't show the negative number.

Medida = IF(SUM('TABELA REPASSE'[SALDO - FORÇAS ESTADUAIS]) < 0 , 0, SUM('TABELA REPASSE'[SALDO - FORÇAS ESTADUAIS]))
 
1.png

Thank you for your help

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@leandrocsouza 

If you have a category column use it in place of SALDO - FORÇAS ESTADUAIS inside INSCOPE.

Medida =
VAR __Sum =  SUM ( 'TABELA REPASSE'[SALDO - FORÇAS ESTADUAIS] ) 
Return
IF(
    ISINSCOPE ( TABELA REPASSE'[SALDO - FORÇAS ESTADUAIS]),
    TABELA REPASSE'[SALDO - FORÇAS ESTADUAIS],
    IF ( __Sum < 0 , 0, __Sum)
    )
)

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

5 REPLIES 5
leandrocsouza
Frequent Visitor

Thanks a lot for the help ! 
OBRIGADO ! 😁

Fowmy
Super User
Super User

@leandrocsouza 

If you have a category column use it in place of SALDO - FORÇAS ESTADUAIS inside INSCOPE.

Medida =
VAR __Sum =  SUM ( 'TABELA REPASSE'[SALDO - FORÇAS ESTADUAIS] ) 
Return
IF(
    ISINSCOPE ( TABELA REPASSE'[SALDO - FORÇAS ESTADUAIS]),
    TABELA REPASSE'[SALDO - FORÇAS ESTADUAIS],
    IF ( __Sum < 0 , 0, __Sum)
    )
)

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

PietroFarias
Resolver II
Resolver II

Do you want to just sum the positive values?

I want to add up all the values, positive and negative. But if the total is negative, I want to show 0.

But column information must remain negative numbers.


See if this example helps you.

PietroFarias_0-1635171843818.png

PietroFarias_1-1635171893919.png

 

Medida =
VAR ListItens =
    VALUES ( Tabela1[ID] )
VAR Result =
    IF (
        HASONEVALUE ( Tabela1[ID] ),
        SUM ( Tabela1[VALOR] ),
        0
    )
RETURN
    Result

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors