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
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")