DAX

ARTICLE

Strange behavior of HASONEVALUE and SELECTEDVALUE

I recently stumbled across a strange behavior of HASONEVALUE, which also impacts the SELECTEDVALUE function. When the only selected item in a column is a numeric value 0 and the column also contains a blank value, there is a bug in the current implementation that does not identify such a

ARTICLE

Querying raw data to Tabular

This article describes how to extract raw data stored in the Tabular engine, used by Analysis Service Tabular, Power BI, and Power Pivot.

ARTICLE

Controlling drillthrough using Detail Rows Expressions in DAX

The Detail Rows Expression in a Tabular model provides the user with control over the drillthrough results obtained by showing details of a measure. This article describes typical DAX expressions you can use in this property.

TOOL

DAX Studio

DAX Studio is a tool to write, execute, and analyze DAX queries in Power BI Designer, Power Pivot for Excel, and Analysis Services Tabular. It includes an Object Browser, query editing and execution, formula and measure editing, syntax highlighting and formatting, integrated tracing and query execution breakdowns.

TOOL

VertiPaq Analyzer

VertiPaq Analyzer is useful to analyze VertiPaq storage structures for a data model in Analysis Services Tabular. A complete description and short tutorial is available in the article Data Model Size with VertiPaq Analyzer.

TOOL

Power Pivot Utilities

Power Pivot Utilities in an Excel add-in (based on a collection of VBA macros) that helps documenting PowerPivot models and facilitates the creation of pivot tables connected to the data model.

ARTICLE

Filtering and comparing different time periods with Power BI

This article introduces a technique to filter and productively compare two time periods with Power BI.

ARTICLE

Avoiding circular dependency errors in DAX

This article explains how DAX handles dependencies between tables, columns and relationships, to help you avoid circular dependency errors.

VIDEO

DAX Studio 2.7 – Improved Debug Experience

DAX Studio 2.7 largely improved the debug experience by adding several feature described in this video: Tooltips for column statistics, capture all queries, and generate dependent measures. How to download DAX Studio (free and open source).

ARTICLE

Using KEEPFILTERS in DAX

This article explains how to use KEEPFILTERS to intersect instead of overriding an existing filter context in DAX, simplifying the code and improving performance.