You need to deploy a solution for the planned self-service reports that will be used by the sales department managers. What is the best solution you should deploy? More than one answer choice may…

A filter restricts which data is visible but does not create a reportable metric or performance indicator that managers can use in self-service reports.

A KPI (Key Performance Indicator) is specifically designed to surface business performance data for decision-makers. KPIs in tabular and multidimensional models expose a base measure, a target value, and a status threshold, giving sales managers an immediate visual indication of performance against goals without requiring them to build their own calculations.

A calculated column computes a row-level value stored in the model table and is not a reporting object that managers can directly consume as a performance indicator.

A measure aggregates data and can power a KPI, but on its own it lacks the status thresholds and target values that make self-service performance reporting meaningful for managers.