Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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".    
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
Anonymous
Not applicable
5 years ago

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's avatar
amitchandak
Super User
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    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.