Forum Discussion
Penn
Resolver I
Resolver IHow to filter a table before ALLSELECTED
Hi All,
How do I filter a table before using ALLSELECTED function?
Before:
ALLSELECTED('Orders')
Now I want to achieve:
'Calendar'[Date] is a slicer on the page.
FILTER(ALLSELECTED('Customer Portal Orders'), AND('Customer Portal Orders'[Order date].[Date] >= MIN('Calendar'[Date]), 'Customer Portal Orders'[Order date].[Date] <= MAX('Calendar'[Date])))
Doesn't work the way that I expected. [Order date] outside of 'Calendar'[Date] is still showing.
Thanks.
