This article is about the state of AI tools with Power BI, and how to use the model context protocol (or MCP) to interact with and control Power BI or Fabric with a large language model (or LLM). Read more
ALLSELECTED is a powerful, yet dangerous function. This article describes the best practices to follow to avoid falling into the pitfalls involved with ALLSELECTED. ALLSELECTED CALCULATE modifier Returns all the rows in a table, or all the values in a… Read more
When should you use DISTINCT over VALUES in DAX? Here is how to write resilient measures that survive bad data and model changes. DISTINCT Returns a one column table that contains the distinct (unique) values in a column, for a… Read more
In this article, we examine the details of executing DAX code, with a focus on how the IF function is implemented in various scenarios. IF Checks whether a condition is met, and returns one value if TRUE, and another value… Read more