09 Aug 2025
Common Pitfalls with VALUES, DISTINCT, and VALUE in Power BI
A practical explanation of common mistakes developers make when using VALUES, DISTINCT, and VALUE in Power BI, and how to avoid unexpected results.
DAX
19 Apr 2025
Playing with Totals in Power BI
A practical guide to understanding and controlling totals in Power BI, including common mistakes and techniques to get accurate results.
05 Oct 2024
Going Beyond with DAX Studio
How to move beyond basic usage of DAX Studio and use it effectively for performance analysis, query testing, and deeper model insights.
31 May 2024
Highlighting Top N Results Using RANKX and TOPN in Power BI
A practical guide to using RANKX and TOPN in Power BI to dynamically highlight top N values and build more insightful reports.
17 May 2024
How to Handle Blanks Effectively in Power BI
A practical guide to understanding and handling blank values in Power BI, including common pitfalls and techniques to avoid incorrect calculations.
19 Apr 2024
Optimizing Measures with DAX Studio in Power BI
A practical guide to using DAX Studio to analyze and optimize measures in Power BI for better performance and cleaner model design.
09 Feb 2024
Ultimate Beginner’s Guide to DAX Studio
A complete beginner-friendly guide to using DAX Studio for analyzing queries, improving performance, and understanding your Power BI data model.
07 Jul 2023
How to Use USERELATIONSHIP in DAX (Power BI Guide)
A practical explanation of how USERELATIONSHIP works in DAX, when to use it, and how to handle multiple relationships in Power BI.
23 Jun 2023
Do We Really Need KEEPFILTERS in DAX?
An explanation of how KEEPFILTERS works in DAX, when it is necessary, and how it affects filter context in Power BI calculations.
28 Apr 2023
Rolling Totals vs Running Totals in Power BI: What’s the Difference?
A clear explanation of the difference between rolling totals and running totals in Power BI, including practical examples and common use cases.
24 Mar 2023
Why Totals Look Wrong in Power BI (And How to Fix Them)
An explanation of why totals sometimes appear incorrect in Power BI and practical techniques to fix common DAX and context-related issues.
10 Mar 2023
Introduction to Calculation Groups in Power BI
An introduction to calculation groups in Power BI, how they work, and how they simplify time intelligence and reusable DAX logic.
18 Nov 2022
Dynamic Titles in Power BI
A practical guide to creating dynamic titles in Power BI using DAX to make reports more interactive and context-aware.
08 Oct 2022
Understanding SUMMARIZE in DAX (Power BI Guide)
A practical guide to understanding the SUMMARIZE function in DAX, how it works, and when to use it in Power BI data models.
09 Sept 2022
Implicit vs Explicit Measures in Power BI
A clear explanation of the difference between implicit and explicit measures in Power BI, and why explicit measures are recommended for better model control.
02 Sept 2022
Using Variables in DAX (Power BI Guide)
A practical guide to using variables in DAX to improve readability, performance, and maintainability of Power BI calculations.
26 Aug 2022
ALL vs ALLSELECTED vs ALLEXCEPT in DAX (Power BI Guide)
A clear explanation of the differences between ALL, ALLSELECTED, and ALLEXCEPT in DAX, including how they affect filter context in Power BI.
22 Aug 2022
FILTER vs KEEPFILTERS in DAX (Power BI Guide)
A practical comparison of FILTER and KEEPFILTERS in DAX, explaining how each function affects filter context and when to use them in Power BI.
27 Feb 2022
Calculated Columns vs Measures in Power BI
A clear explanation of the difference between calculated columns and measures in Power BI, including when to use each and how they impact performance.
20 Feb 2022
RELATED vs LOOKUPVALUE in Power BI: What’s the Difference?
A practical comparison of RELATED and LOOKUPVALUE in Power BI, explaining how each function works and when to use them in DAX calculations.
02 Jun 2021
7 Commonly Used DAX Expressions in Power BI
A practical overview of seven commonly used DAX expressions in Power BI and how they are applied in real-world reporting scenarios.