Filter with negative values

[Annemie19]

Hi There, 

I have a days overdue measure which has values 973 and -3900  I only want to see values that are larger than or equal to -90. 

In the filter panel when I use the filter greater than or equal to -90 for 'days Overdue' it brings up nothing

How else can I define this?

[Anonymous]

Hi @Annemie19 ,

It's weird, the screenshots you provided looks fine. It's better to share the pbix to us if you don't have any Confidential Information.

Best Regards,

Jay

[FarhanAhmed]

How does  'days Overdue' are calculating?

Are you sure you do have +ve values in the table visual? Any other filter on the page level or report level that might restricting your data ?

[Annemie19]

My days ovedue are calculated as follows:

Days Overdue = (DATEDIFF([AA Last Performance date],TODAY(),DAY)).

[FarhanAhmed]

If you have created a calculated column "Days Overdue" then this should work as desired unless you have some slicer or filters restricting the data.

Try to create a new table and put Days Overdue in that table and try restricting data there to see if it is returning blank or some values.