SSAS

ARTICLE

The definitive guide to ALLSELECTED

ALLSELECTED is a powerful function that can hide several traps. This article is an in-depth analysis of the behavior of ALLSELECTED, explaining shadow filter contexts, what they are and how they are used by ALLSELECTED.

ARTICLE

Context Transition and Filters in CALCULATE

This article explains how the context transition interacts with the filter arguments of a CALCULATE function in DAX. This is important in order to avoid unexpected results with complex calculations made in filter arguments.

ARTICLE

What has happened in the DAX world in 2017

We are approaching the end of 2017, so it is a good time to review what happened in the DAX world this year, what we’ve been up to at SQLBI and what is going to happen in 2018. New DAX functions in 2017 Microsoft released ten new DAX functions in

ARTICLE

Computing same product sales in DAX

This article shows a technique in DAX to compute the sales volume of products that were available right from the beginning of a selected time period, ignoring products introduced afterwards.

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

Tabular Editor

Tabular Editor is an editor alternative to SSDT for authoring Tabular models for Analysis Services even without a workspace server.

TOOL

DAX Editor

DAX Editor is an extension to SSDT that makes it easier to edit DAX measures in a Microsoft Analysis Services Tabular project.

TOOL

SSAS Tabular Translator

SSAS Tabular Translator is an editor for the JSON translation files exported and imported by SQL Server Data Tools for a Tabular model in compatibility version 1200 or later.

ARTICLE

Storage differences between calculated columns and calculated tables

This article compares the differences between calculated columns and calculated tables from a processing and storage point of view.