If you're using wireless on a laptop, you can still get Wake on Demand to work but there are additional requirements like having recent hardware and leaving the laptop open while sleep or attaching the display to an external monitor.
If you have a desktop connected by ethernet, the Wake on Demand feature used with an Apple TV is pure awesomeness.