Power BI DAX secrets - (Learn DAX formulas for Power BI)

Learn to handle errors in DAX by creating new columns and using iserror and iferror to return blanks or safe values for divisions, including the safe divide function.

Learn how to use DAX aggregation functions in Power BI, including sum for a single column and sumx for row-level expressions across a table.

Discover how variables in DAX boost performance and readability by computing values once and reusing them in measures, such as total marks and rating.

Explore how filter context drives DAX measures in Power BI, using country and product slicers to analyze total sales by country, category, and colour.

Power BI DAX secrets: row context clarifies how per-row calculations interact with filter context. Explore how slicers and subject filters drive row-by-row sums using measures like SUMX.

Explore the DAX filter function in Power BI, applying a filter expression to a table within current filter context and building sumx measure for total sales with country and gender.

Learn how to ignore filter context with the all function in Power BI DAX by creating a measure that computes sales across all countries and genders, and calculate percentage totals.

Explore how the allselected function in DAX resolves slicer filter issues in Power BI by ignoring inner filters while honoring external filters, and learn to create measures for percentage calculations.

Rank employees by experience in Power BI with a manual DAX approach using variables and current row context to count values greater than the current experience. Compare this with rankx.

Explore how filter context propagates in Power BI, from territory to customers to sales and from sales to products, and learn to enable bi-directional cross-filtering with slicers.

Learn how to access columns from related tables using related and relatedtable, propagate context from the one side to the many side, and count sales transactions.

Explore how the DAX calculate function changes and overrides filter context to produce customized totals, demonstrated with a student and marks data model.

Learn to ignore filter context in Power BI with calculate and all, build a grand total measure, and compute subject percentages across internal and external filters.

Learn to calculate per-student percentages in power bi using the allselected function to repeat the grand total across rows while honoring slicer filters.

Explore how to use the DAX calculate function with filter to derive measures from a one-column table, compare ALL and MAX as syntax sugar, and rewrite with the theta function.

Use the keepfilters function in Power BI DAX to keep external filters, intersecting with existing gender filters to calculate accurate marks.

Explore nested calculate in Power BI DAX with inner and outer calculations on metrics and total marks, and watch the inner override the outer under gender filters.

Explore the Power BI count versus counta functions with a simple model of text, numeric, and logical columns, showing how count counts nonempty values while counta includes logical values.

Explore power BI DAX formulas for countrows, distinctcount, and countblank, including how blank and null values differ across text, numeric, and logical columns, with practical examples.

Explore DAX hasonevalue and selectedvalue to handle single versus multiple selections in a Power BI slicer, returning the selected year or the maximum year when many values are chosen.

Explore the differences between hasonevalue and hasonefilter in DAX. Learn how direct, indirect, and cross filters affect these functions and when each returns true.

Explore the equivalent of hasonevalue using a countrows-based measure that counts rows and returns true when count equals 1, otherwise false.

Explore the DAX values function in Power BI to return unique values from a column or table and calculate the number of customers per occupation within the current filter context.

Learn how the DAX calculate function performs context transition from row context to filter context, enabling total midterm marks per student by propagating filters across related tables.

Explore automatic context transition in DAX by seeing how measures auto-wrap with calculate, enabling row-level filtering when used in calculated columns, and recognizing when to trigger context transition.

Learn to create a date table using calendar auto or a custom date approach, with year, month, and date columns, and relate it to sales data for time intelligence.

Explore how the DAX datesytd function, a time intelligence function, computes year-to-date values, create a YTD measure, and handle fiscal year ends to produce running totals in Power BI.

Learn how the parallelperiod time intelligence function shifts dates in Power BI by an offset, such as going back one year or one month, in DAX.

Learn the sameperiodlastyear time intelligence function in Power BI DAX to compare current selections with the previous year at day or month levels.