A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

One of the restrictions of using CALCULATETABLE to restrict rows is that the filter cannot be applied to calculated measures. Instead FILTER context need to be used for measures.

Technorati Tags: DAX,Tabular Model

DAX Editor

DAX Editor is an extension for Visual Studio that makes easier to work with DAX.

It supports the following features

• DAX syntax highlighting
• DAX formatting. Support for increasing and decreasing format depth using Edit->Advanced->Increase Format Depth or Decrease Format Depth
• IntelliSense support for keywords, functions, columns, and measures. Press Ctrl+Space to show IntelliSense.
• Autocomplete for keywords, functions, tables, columns and measures. Press Ctrl+Space to autocomplete.
• Syntax error reporting using squiggles/Error List
• Brace matching
• QuickInfo support in AutoComplete list that gives description of functions
• F1 help for functions & keywords

Download URL

Technorati Tags: DAX,Visual Studio

24 Hours of Pass - Business Analytics Edition

This 24 Hours of PASS: Business Analytics event will take place on February 5, beginning at 16:00 GMT and will feature 12 webcasts followed by 12 hours of on demand replay.

Sessions

Advanced Analysis Techniques

Advanced Analytics in Excel 2013
Excel is “the” analytical tool in Microsoft’s suite for advanced analysts. Of course, you know that...
Dejan Sarka
An Introduction to Predictive Modeling
This session will show you how to solve a real-world data mining problem by demonstrating the...
Carlos Bossy
Introduction to Querying in DAX
The DAX (Data Analysis Expressions) language can be used to query a Tabular and PowerPivot data...
Marco Russo
Predictive Analytics for Absolute Beginners
In this one-hour preview presentation, we cover the main motivation for learning something about...
Mark Tabladillo, Artus Krohn-Grimberghe

Analytics and Visualization

Adding Valuable Techniques to your Data Science Toolbox
Data Science requires us to see and understand complex patterns in data, so we use techniques like...
Mark Whitehorn
End-to-End Power BI
The aim of this session is to excite you with the potential of Microsoft's new self-service suite...
Peter Myers
Power Query: Beyond the Basics
You already know that you can accomplish a lot within the Power Query user interface. If you are a...
Chris Webb
Small Big Data - Phase 0 - Data Hygiene 
In this talk, we will talk about the starting point for every Big Data project - getting your...
Lynn Langit

Big Data

Has Big Data Killed the EDW?
Big Data technologies have given us the ability to process massive amounts of data at a low cost,...
Stacia Misner
Implementation and Design on the Parallel Data Warehouse
If you need to design a data warehouse that scales for today and into the future, then you need to...
Jason Strate

Information Delivery

DataViz You Thought You Could NOT Do with SSRS
Despite SQL Server Reporting Services (SSRS) being a very flexible and adaptable tool when it comes...
Jason Thomas

Strategy and Architecture

Panel: Myths, Misunderstandings, and Successes in Data Analytics
Big Data, Business Analytics, Data Analytics, NoSQL, Relational . . . do we even agree on what we...
Karen Lopez, Joseph D'Antoni, Lynn Langit, Stacia Misner