Decimal filters.

[Anonymous]

Hi, 

I need to show only the 0.1 >= values, I need to exclude my 0.0 values. 

My current visual filter(Image below) is not accepting decimal 0.1 "greater than or equal to".

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

According to your screenshot, the data (=0.0) you highlighted in yellow is not from [Total of MNCs/Auditor Days] with orange data block but from [Total of NCs/Auditor Days] with blue data block, but you set the condition (value>=0.1) for measure  [Total of MNCs/Auditor Days]  in Filters panel... So if you check the data with orange data block, you will find that the data be filtered correctly.

Best Regards

[Anonymous]

It's hard to say without looking at the PBIX. Hitting apply should work in theory however if you're still having issues, I would create a calculated column (see below) and use that to filter your visual 

Check = 

VAR _MNCs/AuditorDays = CALCULATE(sum('Audit Performance EXT'[mNC])/sum('Audit Performance EXT'[Auditor days]))

Return 

IF(_MNCs/AuditorDays>=0.1,"keep","remove")

[amitchandak]

@Anonymous , Have a click on the apply filter, and still, it does not work.

Can you share the measure formula used?

Can you share a sample pbix after removing sensitive data.

[Anonymous]

Hi Amit,

Here is my formala used, Sorry! I can't send the .pbix file due to security issues.

Total of MNCs/Auditor Days. = CALCULATE(sum('Audit Performance EXT'[mNC])/sum('Audit Performance EXT'[Auditor days]))

[amitchandak]

@Anonymous , try a measure like this, make sure it decimal number with 2 decimal place

Total of MNCs/Auditor Days. = CALCULATE(divide(sum('Audit Performance EXT'[mNC])*1.0,sum('Audit Performance EXT'[Auditor days])))

If you mark a column as % it means .01 is 1

[Anonymous]

Hi Amit,

We have Type has Decimal.

I did the same as you mentioned but still no luck. Is there any other method to achieve this? Thanks for the quick reply.