The formula often includes an aggregate function to evaluate groups. Power BI applies a calculated column expression to all rows in the table, but evaluates only values within the same row.