THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » PowerPivot » PivotTable » DAX   (RSS)
  • The ALLSELECTED function under the cover #dax #tabular #powerpivot #powerbi

    I and Alberto Ferrari recently completed the writing of The Definitive Guide to DAX, and we spent months to correctly describe the internals of evaluation context in this language. There are many details that make data model working with both DAX and MDX, and sometime there are behaviors that are not intuitive to understand. A function that seems ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 5, 2015
  • Difference between DISTINCT and VALUES in DAX

    I recently got a question about differences between DISTINCT and VALUES in DAX and thanks to Jeffrey Wang I created a simple example to describe the difference. Consider the two tables below: Fact and Dim tables, having a single column with the same name of the table. A relationship exists between Fact[Fact] and Dim[Dim]. This relationship ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 7, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement