Topic: SSAS

        456 posts
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.  Read more

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.  Read more

blog post –

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…  Read more

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.  Read more

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.  Read more

tool –

Tabular Editor

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

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.  Free download

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.  Free download