null values

[master_student]

Hello Guys,

I have a measure that returns null values :

I need to remove null values.

Any idea how ?

Here the expression of SLA Globale : =Interval(Sum(TOTAL <[Code Cas], [Date de commande], SLA_GLOBAL, [Statut Cas]> Interval#(SLA_GLOBAL, 's')), 'm')

Thanks

[its_anandrjs]

Try simple if

=if( Interval(Sum(TOTAL <[Code Cas], [Date de commande], SLA_GLOBAL, [Statut Cas]> Interval#(SLA_GLOBAL, 's')), 'm') > 0 ,

Interval(Sum(TOTAL <[Code Cas], [Date de commande], SLA_GLOBAL, [Statut Cas]> Interval#(SLA_GLOBAL, 's')), 'm')

)

[sunny_talwar]

Are you saying that 0 is essentially null? and you want the second row to go away?

[master_student]

yes

[sunny_talwar]

There seems to be other columns (which you might not have included in your screenshot)... are those all 0s? or is there a value within some of them?