Decimal problem. Removing results >-0,1 and <0,1

[setis]

I have a matrix with customers on rows and a measure that calculates my overdue amount. 

I was wondering why i was getting some rows with zero values. I expected to show only customers with values <>0. 

I created a measure for testing:

Measure 10 = IF([OverDue_ALL(Currency)] = 0 ; "Zero" ; "Not Zero")

Then I added 15 decimals and I could see the issue. 

I tried to apply a visual filter on the matrix but it didn't help:

what can I do to round the numbers to 2 decimals and show only <>0 values?

[VipulToshniwal]

Hi,

Try the following measure. If it works, please mark it as the solution.

Measure 10 = ROUNDUP([OverDue_ALL(Currency)],2) AND IF([OverDue_ALL(Currency)] = 0 ; "Zero" ; "Not Zero")

[setis]

Dear @VipulToshniwal , thanks for reaching out. 

The Measure 10 was done only for testing purposes. 

I am interesting in remove zero values and I suspect that there are showing up because there are values like 0,0000000000000001

I have tested: 

Overdue = ROUNDUP([OverDue_ALL(Currency)],2) 

but I'm still getting 0 values:

 

[v-eachen-msft · Accepted solution]

Hi @setis ,

You could check if data is 0 in the Data tab. You could refresh the data to show the correct value.