Summary A user’s filter selections and the filters applied at the report level (not visible to the user) can be computed via DAX functions and then exposed
Category: SQL Server Analysis Services (SSAS)
DAX Variables Design Considerations
Summary DAX variables can be used to optimize performance of queries against SSAS Tabular, Power BI Desktop, and Power Pivot for Excel models by re-using a DAX expression multiple times
Always Be (thinking) Columnar Part II – FILTER()
Summary: You can raise the performance of your DAX code by applying filters in a sequential order from the most selective to least selective. The goal is
Always Be (thinking) Columnar
Summary: If you don’t read this blog post please just consider limiting your DAX metrics and queries to the specific columns and filter contexts required.
MSBI Wishlist (Post SQL Server 16 Release)
At the end of last week’s post on SSAS 2016 I listed off several features and enhancements that will not be in SSAS 16′, at
Top New Features of SSAS 2016
In the previous post I talked about the importance of SSAS as a component to effective BI solutions and overall BI architecture. To reiterate and summarize
Insight Quest 