Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Converting negative to zero

Hi I have measure, and its results are being displayed in the card visual. 

 

If i get a negative number i want to be able to show it as a zero? how can i do that. 

 

Regards

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , You need force that in a measure

    example 

    measure A= if([measure] <0 , 0, [measure])

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , You need force that in a measure

    example 

    measure A= if([measure] <0 , 0, [measure])

  • hashtag_pete's avatar
    hashtag_pete
    Helper V
    5 years ago

    Hi, 

    you can use an if clause 

     

    Measure = 
IF(
    SUM('Finance vw_Debtor' [AR Balance]) - SUM('Finance vw_Debtor'[Credit Limit]) < 0,
    0, 
    SUM('Finance vw_Debtor' [AR Balance]) - SUM('Finance vw_Debtor'[Credit Limit])
)

     

    Does that help? If so, please

    • mark this post as a solution
    • give kudos

    Thanks hashtag_pete