DAX is the formula language in Power BI. Two ideas confuse most beginners: measures and calculated columns. Knowing when to use each one prevents slow reports and wrong totals.
Calculated column
A calculated column adds a new value to every row of a table, worked out once when the data loads. Use it when you need the value to filter or group by, such as an age band for each customer.
Measure
A measure is calculated when a chart needs it, based on the filters in place. Use it for totals, averages and ratios that should change with the report filters, such as total sales or profit margin.
A simple rule
If you will put it on an axis or a slicer, it is probably a column. If you will show it as a number that changes with filters, it is a measure.
Measures to learn first
- SUM and COUNTROWS for totals.
- DIVIDE for safe ratios.
- CALCULATE to change the filter for one value.
- Time functions for month-to-date and year-to-date.
Next step: see our data analytics course at ScholarLogic, or book a free demo class. A counsellor will share the fee and the next batch dates.

Power BI Date Tables: Why Every Report Needs One - ScholarLogic
[…] the measures that use this table in DAX basics, and the modelling ideas in star schema for beginners. Book a free demo class, and ask a counsellor […]