Forum Discussion
Decimal filters.
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".
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
6 Replies
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 , 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 , 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
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")
