Forum Discussion
Filter with negative values
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?
4 Replies
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 ?
My days ovedue are calculated as follows:
Days Overdue = (DATEDIFF([AA Last Performance date],TODAY(),DAY)).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.
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
