how do i add a kpi

Create a Total Sales measure that sums the order-total column, and then use that measure as the KPI’s indicator.

1. Create the Total Sales measure

In Power BI Desktop:

1. In the Data or Report view, right-click your sales table in the Fields/Data pane.
2. Select New measure.
3. Enter this formula, replacing the table and column names with yours:

Total Sales =
SUM ( Sales[Order Total] )

SUM adds every numeric value in the specified column.^1^ Measures also recalculate according to the report’s filters and slicers.^2^

This is correct when each row represents one order, for example:

The measure returns 425.

If an order appears on multiple rows

If the same complete order total is repeated on every product line, a direct SUM would count that order more than once. Sum one value per order instead:

Total Sales =
SUMX (
    VALUES ( Sales[Order ID] ),
    CALCULATE ( MAX ( Sales[Order Total] ) )
)

This creates a distinct list of order IDs, takes one order-total value for each order, and adds those values. SUMX evaluates an expression for every row of a table and then returns the sum.^3^

Do not use that pattern if Order Total is actually the value of each individual product line. For line-level data, use:

Total Sales =
SUM ( Sales[Line Total] )

If line total must be calculated from quantity and price, use:

Total Sales =
SUMX (
    Sales,
    Sales[Quantity] * Sales[Unit Price]
)

2. Add it to a visual

For a simple number without a goal:

1. Select the Card visual.
2. Drag the new Total Sales measure into the card.
3. In Format visual, set the currency, decimal places, and display units.

For a KPI that compares sales with a target:

1. Add Total Sales to a temporary chart as the value.
2. Add a date field, such as Calendar[Month], as the trend axis.
3. Sort the date axis in ascending chronological order before converting the chart; KPI visuals do not provide a sorting option after conversion.
4. Select the KPI icon in the Visualizations pane.
5. Assign:
   • Indicator/Value: Total Sales
   • Trend axis: your date or month field
   • Target: a sales-target measure or field
6. Open Format visual to configure currency, target label, icons, and whether higher values are better.^4^

A KPI is intended to evaluate a measure against a defined target. If no target or trend is available, a Card is usually the appropriate visual for displaying total sales.

References

1. SUM
2. DAX overview
3. SUMX
4. Create key performance indicator (KPI) visualizations