Author: Tomas Zakarevičius

Learn the difference between Row context and Filter context in DAX, how they work together, and how CALCULATE changes filter context in Power BI.

Learn how DAX functions ALL, REMOVEFILTERS, and KEEPFILTERS control filter context in Power BI – differences, examples, and when to use each.

Learn how the DAX CALCULATE function works in Power BI – syntax, examples, changing filter context, and common mistakes.

Learn how DAX iterator functions SUMX, AVERAGEX, COUNTX, and RANKX work in Power BI, the difference from SUM, and when to use them.

Learn the differences between DAX COUNT, COUNTA, COUNTROWS, DISTINCTCOUNT, and COUNTX functions in Power BI – and when to use each.

Learn DAX basics in Power BI – calculated columns vs measures, row and filter context, X functions, and Time Intelligence.

Learn the difference between Star and Snowflake schema in a Power BI data model – when to choose which, and why simplicity usually wins.

Learn what a Power BI data model is, what relationship types exist, how filter direction works, and data model best practices.

Learn what Power Query and the ETL process are in Power BI – Extract, Transform, Load, common actions, and typical data preparation mistakes.

Learn what Power BI is, where it’s used, its ecosystem (Desktop, Service, Mobile, Gateway), and how to get started with this tool.