This video demonstrates how to set up a KPI for a calculated field in Power Pivot.
------------------------