Converting negative to zero

[Anonymous]

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

[hashtag_pete]

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

[amitchandak · Accepted solution]

@Anonymous , You need force that in a measure

example 

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