Mar 4, 2014
NEXT EVENTS: | NEW DAX PATTERNS:
Parameter Table
| The Parameter Table pattern is useful when you want to add a slicer to a PivotTable and make it modify the result of some calculation, injecting parameters into DAX expressions. |  |
Static Segmentation
 | The Static Segmentation pattern groups a continuous numeric value in a finite number of clusters by using a configuration defined in a parameter table. |
The static segmentation happens in a calculated column that is useful when you want to filter and group data according to the range of values.
The parameter table is invisible and used only to control the segmentation algorithm. | FILTER vs CALCULATETABLE:
optimization using cardinality estimation
A common best practice is to use CALCULATETABLE instead of FILTER for performance reason.
This article by Marco Russo explore the reasons of that and explain when FILTER might be better than CALCULATETABLE.
» READ ARTICLE | ADVANCED DAX WORKSHOP:
Last seats in Amsterdam
Just a few seats remaining for our advanced DAX course on Mar 17-18-19 in Amsterdam.
Don't miss it: hands-on-lab with our experts included!
» REGISTER NOW | EARLY BIRD EXPIRING:
SSAS Tabular Workshop
Don't miss 3 days of Tabular modeling in Microsoft SQL Server Analysis Services with our certified experts, on Apr 1-2-3 in Antwerp, BE.
Don't wait too long, the Early Bird expires next week!
» REGISTER NOW AND SAVE 300€ |
|
| SQLBI is a brand of Loader. 2006-2014 © All rights are reserved. |    | You are receiving this mail because we have registered your interest in SQLBI.
If our records are wrong or you'd like to make a change to the type of emails you receive, unsubscribe |
|
|
|