Quick answer
FILTER function in Power BI DAX is a Power BI DAX example for creating reusable calculations in reports. Use it as a measure pattern, then adapt table and column names to your model.
Large Sales = CALCULATE([Total Sales], FILTER(Sales, Sales[Amount] > 1000))When to use it
Use this DAX pattern when a spreadsheet-style calculation needs to become a reusable report measure. It is especially useful for KPI cards, tables, matrix visuals, and trend charts.
Step-by-step
- Confirm the base columns and relationships in your model.
- Create the base measures first, such as Total Sales or Total Cost.
- Create the final DAX measure using clear names.
- Place the measure in a simple card or table visual to test it.
- Check the result with filters, slicers, and different date ranges.
Excel comparison
In Excel, the same logic often appears as a cell formula or PivotTable calculation. In Power BI, the logic should usually be a measure so it responds to filters and slicers.
=IFERROR(B2/C2,0)Common mistakes
- Writing one complex measure before testing the base measures.
- Using a calculated column when a measure would respond better to filters.
- Forgetting that DAX results depend on filter context.
- Using / instead of DIVIDE when the denominator may be zero or blank.