Page 31 of 320 results for ssas
• blog post

# Using SUMMARIZECOLUMNS instead of SUMMARIZE in #dax #powerbi #ssas #tabular

One of the latest addition to DAX has been the ability to apply an external filter context to SUMMARIZECOLUMNS, which makes this function a perfect replacement for SUMMARIZE in DAX. In The Definitive Guide to DAX I introduced such a…  Read more

• blog post

# New edition of the Analysis Services Tabular book #ssas #tabular

Last year I and Alberto Ferrari wrote a new edition of the Analysis Services Tabular book, which official title is Tabular Modeling in SQL Server Analysis Services (2nd Edition). Some delay in editing and production delayed the printing, but the…  Read more

• blog post

# Dimensional modeling with Ranged Dimensions

A ranged dimension is a dimension that is used to have a discrete view of a continuous measure. A good example of this is the analysis of amount sold per order. In AdventureWorks we have, for each line of an…  Read more

• blog post

# Thinking in DAX: Counting Products in the Current Status with PowerPivot

One of my readers came to me with an interesting formula to compute in PowerPivot. Even if I donâ€™t normally post about very specific scenarios, I think this time it is interesting to write a blog post since the formula…  Read more

• blog post

# Creating a copy of a BISM Tabular project

Using Visual Studio to author SSAS Multidimensional projects, I was used to copy the project, deploy it with another name and then proceed with updates, until I was satisfied with the final result. Then, working with the two projects side-by-side…  Read more

• blog post

# Circular Dependencies in DAX

What is a circular dependency? If A depends on B and B depends on A, then you have a circular dependency. As programmers, we know that they should be avoided to obtain a working system. All this looks fine but,…  Read more

• blog post

# New Whitepaper from SQLBI: Vertipaq vs ColumnStore

At the end of June 2012, I was in Amsterdam to present some sessions at Teched Europe 2012 and, while preparing the material for the demos (yes, the best demos are the ones I prepare at the last minute), I…  Read more

• 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.  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

• white paper

# The Many-to-Many Revolution

This white paper explores many different uses of many-to-many relationships in both SQL Server Analysis Services Multidimensional and Tabular models.  Read more