Forum Discussion
Filter issue
Hello Community - I have an issue with a filter that is wreaking havoc on my report. Today a colleague asked me to filter a report by the field of the name of the person that entered the order....
Assuming that your Date table is marked as date table and covers your whole order date range, have you tried SAMEPERIODLASTYEAR instead?
NewMeasure =
CALCULATE (DISTINCTCOUNT ( 'Orders 2'[Order] ), SAMEPERIODLASTYEAR('Date Table'[Date))Also, why do you need the ISBLANK logic?If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
It is likely that when you filtered to a single person, that person didn't have orders on all dates and triggered that error in your last_date variable. I would encourage you to calculate that variable w/o time intelligence functions (or use the Date table columns instead).
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat